SQL Server dilemma, performance
Posted
by Woland
on Stack Overflow
See other posts from Stack Overflow
or by Woland
Published on 2010-05-04T10:17:21Z
Indexed on
2010/05/04
10:48 UTC
Read the original article
Hit count: 131
sql-server
|sql
Hello
I am creating app where user can save options
witch one is better?
to save into user table varchar feeld smthing like ('1,23,4354,34,3') query for this is select * from data where CHARINDEX ( 'L', Providers , 0 ) > 0
create other table where user options are and just add rows select * from data where Providers in (select Providers from userdata where userid=100)
thanks for help
© Stack Overflow or respective owner