SQL PROC
CREATE PROC UrunAra
@aciklama NVARCHAR(max)
AS
SELECT distinct(urunkodu),marka,fiyat,aciklama,urunadi,kdv FROM Urunler WHERE aciklama LIKE '%' + @aciklama + '%'
EXEC UrunAra @aciklama='adet'
CREATE PROC UrunAra
@aciklama NVARCHAR(max)
AS
SELECT distinct(urunkodu),marka,fiyat,aciklama,urunadi,kdv FROM Urunler WHERE aciklama LIKE '%' + @aciklama + '%'
EXEC UrunAra @aciklama='adet'