Thansk for reply  but STRING_SPLIT does not work on sql server that I work.

Should I use below bode?

set @isexist=(select count(*) from GNL_OgretmenDevamsizlikGirisLog

where OgretmenID=@ogretmenID

and DersYiliID=@dersyiliID

and SinifID=@sinifID

and DersID=@dersID

and

Convert(date,GirisTarihi) = Convert(date,getdate())

)

if(@isexist>0)

begin

end

i already set pageslug nvarchar(450).

and i couldset pageslug field as index.

As i know, indexed fields increase searching time. For example primary key. But i don't know exactly, this is true...

thanks it worked. i also want to ask one question. pwhen pageslug is set as index, searching time increase. i know right, do i?

Thanks.

i have a table ProductTrack.Table is like below: Table field are :

ProductTrackId primary key

ProductId int

SizeId int

Quantity int

Process int

i keep track product stocks with this table. ProductId field is related with...

thank you so much. it worked.

thanks. i look at that aticle. i hope i solve my problem.

Again thanks.

but i enter baslik from textbox. that is @baslik value can change. also if i use as below:

@baslik nvarchar(max)=null,

@icerik nvarchar(max)=null

AS

BEGIN

insert into makale values(@baslik,@icerik)

END

normal proc not dinamic.

it runs and accept '...

proc name...

@baslik nvarchar(max)=null,

@icerik nvarchar(max)=null

AS

BEGIN

declare @sqlcum nvarchar(max)

set @sqlcum ='insert into makale (baslik,icerik) values(N'''+@baslik+ ''',N'''+@icerik+ ''')'

exec(@sqlcum)

................

my dinamic query is this. i use this on a web site project. i use textbox, fckeditor...

Thanks..

thanks. it worked.

Hi. i guess, i wrote something wrong.(also my english is not very well:)) )

i have 2 table: Category and Products. In products table, there is a field that suply relation...

oh. thank you so much. this is what i want. Reaaly so thanks.

i tried

"select * from myurun

WHERE sirano BETWEEN (@BatchSize * (@WhichPage -1)) AND (@BatchSize * (@WhichPage -1))...

i tried like this.

ALTER PROCEDURE [dbo].[sp_listcategoryproducts]

@dolar float,

@katid int,

@sayfano int

as

BEGIN

with myurun

as

(

select (ROW_NUMBER()over(order by UrunKategoriID))as sirano,UrunKodu,UrunAdi,UrunResim,UrunStok,UrunFiyat,

case

when UrunKDVDurumID=1 then 'KDV Dahil'

else '+KDV'

end as KDVDurum,

dbo.f_urunfiyati(UrunKDVDurumID,UrunParaTipi,UrunFiyat,@dolar) as ToplamTutar,

case

when UKampanya=1 then 'Indirimli'

end as indirim,

case

when UKampanya=1...