세상에 도움이 되는 사람이되자

C:\Users\Administrator\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup

출처 : http://hackhyun.tistory.com/193

Windows 7 의 경우 : C:\Users\사용자\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

CREATE TABLE FIRSTTB(A CHAR(1))

CREATE TABLE SECONDTB(A CHAR(1))

CREATE TABLE THIRD(A VARCHAR(30))

BEGIN TRAN

       DECLARE @I INT

       SET @I = 5

       WHILE (@I <= 15)

       BEGIN

             INSERT INTO FIRSTTB VALUES(@I)

             IF(@@ERROR <> 0) GOTO _RollBack

             INSERT INTO SECONDTB VALUES('AA')

             IF(@@ERROR <> 0) GOTO _RollBack

       END

COMMIT TRAN

GOTO _DataSave

_RollBack:

IF @@TRANCOUNT > 0 BEGIN

       ROLLBACK TRAN

       INSERT INTO THIRD VALUES('에러발생')

END

RETURN

_DataSave:

RETURN