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 2005 Forums
 Transact-SQL (2005)
 How to test IN function

Author  Topic 

bh0526
Yak Posting Veteran

71 Posts

Posted - 2010-05-04 : 08:09:18
Dumb question but if I right click on a table in SS Management Studio and then enter a sql statement with the IN function and then run the query, how do I enter more than one value when the query parameters popup appears? If I enter one value then it works. If I enter 2 values seperated by a comma I get rows returned.

Thanks,

Bob

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2010-05-04 : 08:52:10
You right click a table with SSMS and enter a SQL statement?
How?



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-05-04 : 09:55:27
Rather open a query window and write queries yourself.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -