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'