–创建存储过程
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
–创建存储过程
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