Update if record exist in database using SQL Server Stored Procedure example

Hi,

You can use same procedure to Update.and If you are updating then Pass Id else dont pass Id.

Refer below code.

SQL

CREATE PROCEDURE InsertName
	@Id INT = NULL
	@Name VARCHAR(50)= '',
	@Birthday VARCHAR(12)= '',
	@District INT = 0
as
BEGIN
	DECLARE @DATE DATETIME
	IF LTRIM(RTRIM(@Birthday)) <>''
	SET @DATE= convert(DATETIME,@Birthday,103)

	IF NOT EXISTS(SELECT Count(Id) FROM ParsonTable WHERE Id = @Id) OR @Id IS NULL
	BEGIN
		INSERT INTO ParsonTable(FirstName,Birthday,DistrictId) VALUES(@Name,@date,@District)
	END
	ELSE
	BEGIN
		 UPDATE ParsonTable
		 SET FirstName = @FirstName
			,Birthday = @Birthday
			,District = @District
		 WHERE Id = @Id
	END
END