存储过程step by step

1.sqlServer创建存储过程

CREATE PROCEDURE glInsert @name varchar(50)
 AS
insert into s_paytype values(
@name
)
GO

2.运行上面的存储过程，在SQL查询器中

exec glInsert 'zhao3'
或
execute glInsert 'zhao2'

3.修改存储过程

ALTER  PROCEDURE glInsert @name varchar(50),@end varchar(30)
 AS
insert into s_paytype values(
@name+@end
)
GO

4.运行修改后的存储过程

exec glInsert 'zhao3','ending'

5.数字是参数的

CREATE  PROCEDURE glDelOne @id bigint
AS
delete from s_paytype where id=@id
GO

6.运行上面的存储过程

execute glDelOne 1

7.无参数的

CREATE PROCEDURE glDelAll
AS
delete from s_paytype

8.运行

execute glDelAll