create proc search
@name nvarchar(50) , @id int
as
select * from
where
(@name = '' or name = @name)
and (@id = 0 or id = @id)
اگه منظورتون رو درست فهمیده باشم
create proc search
@name nvarchar(50) , @id int
as
select * from
where
(@name = '' or name = @name)
and (@id = 0 or id = @id)
اگه منظورتون رو درست فهمیده باشم