DEFINITIONS

Definitions More Info.
Definition ID507
TitleSQL
CategoryNOTES
DefinitionSQLCMD : WHILE LOOP ile INSERT islemi WTIH ROLLBACK
Definition Descriptionuse YUKSEL
GO
DECLARE @i int
BEGIN TRANSACTION
SET @i = 0 while (@i <= 1000)
BEGIN
print @i
INSERT INTO hede2 VALUES ('cunay', @i)
SET @i = @i + 1
IF @@ERROR <> 0
BEGIN
raiserror('Hata var', 16,-1) ROLLBACK TRANSACTION
END
END
COMMIT TRANSACTION
RecordBycunay
Record Date15-05-2014 12:15:00
Düzenle
Kopyala
Sil