1.添加部门
Create PROCEDURE demo_deptadd
@name varchar(20),@description varchar(20),@leader varchar(20),@phone varchar(20),
@address varchar(20),@starttime varchar(20),@info varchar(40)
AS
insert into department
(name,description,leader,phone,address,starttime,info)values
(@name,@description,@leader,@phone,@address,@starttime,@info)
复制内容到剪贴板 程序代码
Create PROCEDURE demo_deptadd
@name varchar(20),@description varchar(20),@leader varchar(20),@phone varchar(20),
@address varchar(20),@starttime varchar(20),@info varchar(40)
AS
insert into department
(name,description,leader,phone,address,starttime,info)values
(@name,@description,@leader,@phone,@address,@starttime,@info)
Tags: SQL Server SQL存储过程