|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
August 5th, 2003, 10:46 PM
|
|||
|
|||
|
Where In()
I need a select statement that will bring me a range of selection data.
SELECT * FROM Languages WHERE LanguageId In (@LanguageId) Order By LanguageName Can the in condition be passed as a parameter The parameter will be "it,pt-br,es,de-de" If not how can a Get the same result. Thanks
|
|
#2
August 6th, 2003, 09:33 AM
|
|||
|
|||
|
dynamic SQL?
You can always opt for dynamic sql:
Code:
DECLARE @sql nvarchar(500)
DECLARE @LanguageId nvarchar(100)
SET @LanguadeId = 'it,pt-br,es,de-de'
SET @sql = N'SELECT * FROM Languages' + CHAR(13) +
N'WHERE LanguageId In (' + @LanguageId + N') ' + CHAR(13) +
N'Order By LanguageName'
Execute sp_executesql @sql
__________________
- Rogier Doekes
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > Where In() |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
