SQL存储过程之删除

–创建存储过程
USE TestDB
GO
if OBJECT_ID(‘DeleteStudent’,‘P’)IS NOT NULL
Drop Procedure DeleteStudent
go
Create Procedure DeleteStudent
@SNO INT
AS
delete from Student Where SNO=@SNO
go

–调用存储过程

exec TestDB.dbo.DeleteStudent @SNO=95220