IPGraySpace: SQL Server - How to create stored procedure in SQL Server with commit and rollback
IPGraySpace: SQL Server - How to create a stored procedure in SQL Server with commit and rollback statement
This video shows How to create a stored procedure in SQL Server with commit and rollback statement
1. log in to SQL server management studio
2. choose the database 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 a zipcode table I have 80000 records in there it is good to
test with huge rows
5. create a backup table for the zip code, in your case you choose the backup table of step 3,
have scripts ready to create a table
6. create a store procedure
7. take the default layout SQL server management studio to give you then change it line by line
8. create a basic stored procedure template for the stored procedure with commit and rollback statement
9. add the business logic - in this case, we are going to insert the chosen table data to backup table
10. execute stored procedure
11. View results
if you don't have an SQL server ......... watch the IPGraySpace video
IPGraySpace: SQL Server - How to download and install SQL Server Express in windows 10
if you don't have an SQL server management studio ......... watch the IPGraySpace video
IPGraySpace: 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 IPGraySpace video
IPGraySpace: SQL Server - How to create a user account in SQL Server Express 2017
IPGraySpace: SQL Server - How to create new user, database with new user and create a table in SQL server
Follow more IPGraySpace videos
-----------------
thank you for watching the IPGraySpace video
please share, subscribe, and comment
visit
www.ipgray.com
www.ipgrayspace.com
for more IT articles, documents, and videos
-
1:55
IPGraySpace
3 years agoIPGraySpace: SQL Server - How to get the list of stored procedure from SQL Server schema
18 -
9:59
IPGraySpace
3 years agoIPGraySpace: Sql Server - How to create and execute function in Sql Server
30 -
10:47
IPGraySpace
3 years agoIPGraySpace: Sql Server - How to create user account in SQL Server Express 2017
59 -
10:21
IPGraySpace
3 years agoIPGraySpace: Sql Server - How to create new user, data base in express 2017
33 -
4:52
IPGraySpace
3 years agoIPGraySpace: Glassfish - How to create domain in Glassfish
20 -
2:13
IPGraySpace
3 years agoIPGraySpace: How to create java project in IntelliJ IDEA
21 -
0:40
IPGraySpace
3 years agoIPGraySpace: How to create JavaX project in IntelliJ IDEA
9 -
5:32
IPGraySpace
3 years agoIPGraySpace: Eclipse - How to configure sonarqube server in eclipse
28 -
3:34
IPGraySpace
3 years agoIPGraySpace: MySQL to SQL server- how to run MySQL db scripts in SQL server with minor changes
4 -
3:00
IPGraySpace
3 years agoIPGraySpace: Netbeans - How to see Glassfish server log window in Netbeans
8