SQL Server Insert, Retrieve, Update, Delete Operations using Stored Procedures Keywords insert update delete using stored procedure,stored procedure with example,stored procedure example. In database, you need to do Insert, Update and Delete. If we want to make a reliable and high performance system then these four operations must be implemented by stored procedures. Stored procedure also prevents Sql Injection attacks and reduce network traffic. For more about stored procedure refer the article Stored Procedure Plan Recompilation and Performance Tuning. Insert Operation. We can insert records into the tables using stored procedure by passing data in input parameters. Images/1380_SQLServer2005Triggers_1.gif' alt='Sql Server 2005 Trigger On Update Example' title='Sql Server 2005 Trigger On Update Example' />Here Mudassar Ahmed Khan has explained with simple examples, how to write Insert, Update and Delete Triggers in SQL Server. This tutorial is applicable for all. We experienced a failure on one of our MS SQL servers this morning and we are currently investigating the cause. One thing I have noticed is a massive jump in the. I need example of SQL Server Update Trigger, Get fields before and after updated to execute sql statments in another table. Ever wanted to use Snapshot or Read Committed Snapshot Isolation Levels in SQL Server Learn how to turn them on safely. Datatypes. Each value manipulated by Oracle Database has a datatype. The datatype of a value associates a fixed set of properties with the value. Below code is used to insert record in the table Employee using stored procedure CREATE TABLE Employee. Emp. ID int primary key, Name varchar5. Address varchar1. Insert into EmployeeEmp. ID,Name,Salary,Address Values1,Mohan,1. Delhi. Insert into EmployeeEmp. ID,Name,Salary,Address Values2,Asif,1. Delhi. Insert into EmployeeEmp. ID,Name,Salary,Address Values3,Bhuvnesh,1. Noida. SELECT FROM Employee CREATE PROCEDURE uspInsert. Figure01.JPG' alt='Sql Server 2005 Trigger On Update Example' title='Sql Server 2005 Trigger On Update Example' />Employee. Name varchar5. 0. Address varchar1. BEGIN TRANSACTION. Insert into EmployeeEmp. ID,Name,Salary,Address ValuesEmp. ID,Name,Salary,Address. IF TRANCOUNT 0. BEGIN commit TRANSACTION. IF TRANCOUNT 0. BEGIN rollback TRANSACTION. END Execute above created procedure to insert rows into table. Declare flag bit. EXEC uspInsert. Employee flag output,1,Deepak,1. Noida. print Successfully inserted. There is some error Execute above created procedure to insert rows into table. Declare flag bit. EXEC uspInsert. Employee flag output,4,Deepak,1. Noida. print Successfully inserted. There is some error now see modified table. Select from Employee Retrieve Operation. We can retrieve data from one or more tablesviews with the help of join, using stored procedure. We can put multiple sql statements with in a single stored procedure. Below code is used to fetch data from a table Employee using stored procedure first we Insert data in the table. Insert into EmployeeEmp. ID,Name,Salary,Address Values1,Mohan,1. Delhi. Insert into EmployeeEmp. ID,Name,Salary,Address Values2,Asif,1. Delhi. Insert into EmployeeEmp. ID,Name,Salary,Address Values3,Bhuvnesh,1. Noida. Now we create a procedure to fetch data. CREATE PROCEDURE uspSelect. Employee. Select from Employee ORDER By Emp. ID Execute above created procedure to fetch data. Select. Employee Update Operation. We can update records of the tables using stored procedure by passing data in input parameters. Below code is used to update a table Employee using stored procedure CREATE PROCEDURE uspUpdate. Employee. flag bit output, return 0 for fail,1 for success. Address varchar1. BEGIN TRANSACTION. Update Employee set SalarySalary, AddressAddress. Where Emp. IDEmp. ID. IF TRANCOUNT 0. BEGIN commit TRANSACTION. IF TRANCOUNT 0. BEGIN rollback TRANSACTION. END Execute above created procedure to update table. Declare flag bit. EXEC uspUpdate. Employee flag output,1,2. Noida. if flag1 print Successfully updated. There is some error now see updated table. Select from Employee Delete Operation. We can delete records of the tables using stored procedure by passing data in input parameters. Below code is used to update a table Employee using stored procedure CREATE PROCEDURE uspDelete. Employee. flag bit output, return 0 for fail,1 for success. BEGIN TRANSACTION. Delete from Employee Where Emp. IDEmp. ID set flag1. IF TRANCOUNT 0. BEGIN commit TRANSACTION. Block Software Windows Xp Firewall there. IF TRANCOUNT 0. BEGIN rollback TRANSACTION. END Execute above created procedure to delete rows from table. Declare flag bit. EXEC uspDelete. Employee flag output, 4. Successfully deleted. There is some error now see modified table. Select from Employee Note. In stored procedure we use output parameter to return multiple values. Generally we use output parameter in stored procedure to get status of the operation as I used above flag output parameter to get operations status whether these are successfully executed or not. Summary. In this article I try to explain basic Insert, Retrieve, Update, Delete Operations using Stored Procedures. I hope after reading this article you will be know how to implement these operations using stored procedure. I would like to have feedback from my blog readers. Please post your feedback, question, or comments about this article.