IPGRAY : Sql Server - How to create stored procedure in Sql Server with commit and rollback

IPGRAY : Sql Server - How to create stored procedure in Sql Server with commit and rollback statement

This video shows How to create stored procedure in Sql Server with commit and rollback statement

1. Login to sql server management studio
2. choose data base you are going to work with
3. choose a table you are going to work with
4. In my case i am going to choose zipcode table i have 80000 records in there it is good to
test with huge rows
5. create a backup table for the zipcode, in your case you choose the backup table of step 3,
have scripts ready to create table
6. create store procedure
7. take the default layout sql server management studio give you than change it line by line
8. create a basic stored procedure template for the stored procedure with commit and roll back statement
9. add the business login - in this case we are going to insert the choosen table data to backup table
10. execute stored procedure
11. view results


if you don't have sql server ......... watch IPGRAY video
IPGRAY : SQL Server - How to download and install SQL Server Express in windows 10

if you don't have sql server management studio ......... watch IPGRAY video
IPGRAY : SQL Server - How to download and install SQL Server Management Studio in Windows 10

how to create sql server user in sql server management studio ..... watch IPGRAY video
IPGRAY : Sql Server - How to create user account in Sql Server Express 2017
IPGRAY : Sql Server - How to create new user, data base with new user and create table in SQL server


thank you for watching IPGRAY video
follow more IPGRAY videos on youtube
please share, subscribe and comment