Run Code
|
Code Wall
|
Users
|
Misc
|
Feedback
|
About
|
Login
|
Theme
|
Privacy
Transaction Test
CREATE TABLE Department ( DeptID int PRIMARY KEY, DeptName varchar(50) NULL, Location varchar(100) NULL, ) GO CREATE TABLE Employee ( EmpID int PRIMARY KEY, Name varchar(50) NULL, Salary int NULL, Address varchar(100) NULL, DeptID int foreign Key references Department(DeptID) ) GO --Now Insert data INSERT INTO Department(DeptID,DeptName,Location)VALUES(1,'IT','Delhi') GO INSERT INTO Employee(EmpID,Name,Salary,Address,DeptID)VALUES(1,'Mohan',15000,'Delhi',1) SELECT * FROM Department SELECT * FROM Employee GO --Transaction with Save Point BEGIN TRANSACTION trans BEGIN TRY INSERT INTO Department(DeptID,DeptName,Location)VALUES(2,'HR','Delhi') IF @@TRANCOUNT > 0 BEGIN SAVE TRANSACTION trans; END INSERT INTO Department(DeptID,DeptName,Location)VALUES(3,'Admin','Delhi') INSERT INTO Employee(EmpID,Name,Salary,Address,DeptID)VALUES(1,'Mohan',18000,'Delhi',1) IF @@TRANCOUNT > 0 BEGIN COMMIT TRANSACTION trans END END TRY BEGIN CATCH print 'Error Occured' IF @@TRANCOUNT > 0 BEGIN ROLLBACK TRANSACTION trans END END CATCH GO
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
aaa
Dynamic Sql command with output variable
Cte recursion
GKM_JOIN_1
Outer Apply successer cell chek and get the result
t1
get inused indexes
STDEV vs STDEVP
SQL Server - UK Holiday Calendar Example
Seq
Please log in to post a comment.