Member
90 Points
73 Posts
Jan 04, 2009 09:53 PM|xuannien84|LINK
i use store Proc @type nvarchar(200) AS Select Id, Name, Type From Products Where Type = @type
if only one type is ok ,more one is error
example:
@type = '1' is oke
@type = 1 or Type = 2 => error
how can to get data with multi criteiar of same field on store Proc
Member
90 Points
73 Posts
query with custom criteria
Jan 04, 2009 09:53 PM|xuannien84|LINK
i use store Proc
@type nvarchar(200)
AS
Select Id, Name, Type
From Products
Where Type = @type
if only one type is ok ,more one is error
example:
@type = '1' is oke
@type = 1 or Type = 2 => error
how can to get data with multi criteiar of same field on store Proc