create proc SearchRow(@ad nvarchar (100), @soyAd nvarchar (100), @telefon nvarchar (15))
as
begin
select * from OrnekTablo where (ADI = @ad or @ad is null) or (SOYADI = @soyAd or @soyAd is null) or (TELEFON = @telefon or @telefon is null)
end
as
begin
select * from OrnekTablo where (ADI = @ad or @ad is null) or (SOYADI = @soyAd or @soyAd is null) or (TELEFON = @telefon or @telefon is null)
end
Yorumlar
Yorum Gönder