03-12-2003, 11:41 PM
|
|
Junior Contributor
|
|
Join Date: Feb 2003
Location: Mumbai
Posts: 259
|
|
Quote:
|
Originally Posted by barski
What's wrong with this. If I have where location = @ins it works but for some reason it doesn't like the in statement. Any help be greatly appreciated
CREATE PROCEDURE dbo.instatement
@ins as nvarchar(100)
as
Select * from locations where location in @ins
|
i think @ is reserve word, |
|
In Statement Variable
Linear Mode
