CURSOR

DECLARE @sehir varchar(11), @sehir_id varchar(20)

DECLARE cr CURSOR FOR
SELECT il_id,adi FROM Iller

OPEN cr

FETCH NEXT FROM cr INTO @sehir_id , @sehir

WHILE @@FETCH_STATUS = 0
BEGIN

UPDATE adresler set il=@sehir_id where il=@sehir

FETCH NEXT FROM cr INTO @sehir_id , @sehir

END


CLOSE cr
DEALLOCATE cr

GO

T-SQL: Get only Date from DateTime

Sadece tarih bilgisidir.... Saat, dakika, saniye hep 0

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))
2009-01-16 00:00:00.000