普通存储过程if exists(select * from sysobjects where name = 'proc_stu') drop procedure proc_stu go create procedure proc_stu as //可执行SQL语句带参数存储过程 if exists(select * from sysobjects where name = 'proc_stu') drop procedure proc_stu go create procedure proc_stu @name varchar(50) ,@age int as //可执行SQL语句带默认参数存储过程if exists(select * from sysobjects where name = 'proc_stu') drop procedure proc_stu go create procedure proc_stu @name varchar(50) = 'Admin' ,@age int = 50 as //可执行SQL语句带输出参数存储过程if exists(select * from sysobjects where name = 'proc_stu') drop procedure proc_stu go create procedure proc_stu @name varchar(50) output ,@age int = 50 as //可执行SQL语句
普通存储过程if exists(select * from sysobjects where name = 'proc_stu')
drop procedure proc_stu
go
create procedure proc_stu
as //可执行SQL语句带参数存储过程
if exists(select * from sysobjects where name = 'proc_stu')
drop procedure proc_stu
go
create procedure proc_stu @name varchar(50)
,@age int
as //可执行SQL语句带默认参数存储过程if exists(select * from sysobjects where name = 'proc_stu')
drop procedure proc_stu
go
create procedure proc_stu @name varchar(50) = 'Admin'
,@age int = 50
as //可执行SQL语句带输出参数存储过程if exists(select * from sysobjects where name = 'proc_stu')
drop procedure proc_stu
go
create procedure proc_stu @name varchar(50) output
,@age int = 50
as //可执行SQL语句
这样的话你只要在sql server端写存储过程就行了