Stored Procedure in MS SQL Server 2005 (Update)

on

I will now describe education about making stored procedures to update the existing data in the table


in the discussion of this education, creation of sql syntax is almost the same as the previous article about education makes stored procedures (insert)

general syntax:
CREATE PROC [name of procedure]
AS
BEGIN
      <syntax sql>
END

example:
CREATE PROC updateuser (@ changepass varchar (20), @ user varchar (10))
AS
BEGIN
update users set pass = @ changepass where username = @ user
END

EXEC updateuser '12345 ',' admin '


Comments

Post a Comment