How to use stored procedures to insert and update data in SQLServer

In this issue, the editor will bring you about how to use stored procedures to insert and update data in SQLServer. The article is rich in content and analyzed and described from a professional point of view. I hope you can get something after reading this article.

Realize

1) return the same data directly (return value: 0)

2) update the data with the same primary key but different data (return value: 2)

3) No data, insert data processing (return value: 1).

[create stored procedure]

Create proc Insert_Update @ Id varchar (20), @ Name varchar (20), @ Telephone varchar (20), @ Address varchar (20), @ Job varchar (20), @ returnValue int output as declare @ tmpName varchar (20), @ tmpTelephone varchar (20), @ tmpJob varchar (20), @ tmpAddress varchar (20) if exists (select * from dbo.DemoData where id=@Id) begin select @ tmpName=Name,@tmpTelephone=Telephone,@tmpAddress=Address @ tmpJob=Job from dbo.DemoData where id=@Id if ((@ tmpName=@Name) and (@ tmpTelephone=@Telephone) and (@ tmpAddress=@Address) and (@ tmpJob=@Job)) begin set @ returnValue=0-- have the same data Directly return the value end else begin update dbo.DemoData set Name=@Name,Telephone=@Telephone,Address=@Address,Job=@Job where id=@Id set @ returnValue=2-- update the data with the same primary key, end end else begin insert into dbo.DemoData values (@ Id,@Name,@Telephone,@Address,@Job) set @ returnValue=1-- without the same data, insert the end

[execution mode]

Declare @ returnValue int exec Insert_Update'15, @ returnValue output select @ returnValue.

Returns a value of 0, which already exists

Return value 1, inserted successfully

Return value 2, updated successfully

The above is how to use stored procedures to insert update data in SQLServer shared by Xiaobian. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.