Stored Procedure in MS SQL Server 2005 (Delete)

This education how to create procedure delete

I will now describe education about making stored procedures to delete 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,update)

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

example:
CREATE PROC deleteuser (@ user varchar (10))
AS
BEGIN
delete from users where username = @ user
END

EXEC deleteuser ' admin '