is SQL oops oriented..??? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

is SQL oops oriented..???

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-04-06 : 09:30:22

kavitha writes "hi guys...
i would relly like to know if sql server is oops (object oriented progrming) oriented...i know SQL server 7.0 is not oops oreiented...i have another problem tooo...
i need to have a table say for eg TEMP..
TEMP
ID COL1 COL2 COL3 COL4
now each column can have multiple values for a single row..
ID COL1 COL2 COL3 COL4
1 X,Y,S G,H W F,C,D,E,R
2 E,X G R,T,W F,C,
3 X H R F

the only thing that i have thought till now is store the values by separating them with the help of ',' as shown above... and another way probably is creating separate tables...so the select statement with respect to all the columns as well as all the values would ceratinly easy...
If i ahec to find total number of people who have values F,W,G,X then the answer shud be 2..
how i do this??? is there any better way that i can do this??"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources