现建两个更新一条数据的存储过程:
CREATE PROCEDURE [dbo].[spupdatecustom]
@id int,
@cname nvarchar(50),
@departID int,
@age int,
@ename nvarchar(50),
@password nvarchar(50)
AS
BEGIN
update
custom
set
cname = @cname,
departID = @departID,
age = @age,
ename = @ename,
password = @password
where id = @id
END
COMMIT TRAN
view sourceprint?create procedure spupdatedepart
(
@departname nvarchar(50),
@description nchar(10),
@id int
)
as
UPDATE [dbo].[department]
SET [departname] = @departname
,[description] = @departname
WHERE id=@id
@id int,
@cname nvarchar(50),
@departID int,
@age int,
@ename nvarchar(50),
@password nvarchar(50)
AS
BEGIN
update
custom
set
cname = @cname,
departID = @departID,
age = @age,
ename = @ename,
password = @password
where id = @id
END
COMMIT TRAN
view sourceprint?create procedure spupdatedepart
(
@departname nvarchar(50),
@description nchar(10),
@id int
)
as
UPDATE [dbo].[department]
SET [departname] = @departname
,[description] = @departname
WHERE id=@id
再新建两个取出所有用户的存储过程:
CREATE PROCEDURE [dbo].[spGetcustom]
AS
BEGIN
select * from custom order by id desc
END
view sourceprint?create PROCEDURE [dbo].[spGetAlldepartment]
AS
BEGIN
select * from department
END
AS
BEGIN
select * from custom order by id desc
END
view sourceprint?create PROCEDURE [dbo].[spGetAlldepartment]
AS
BEGIN
select * from department
END
再新建一个根据ID取出一条数据的存储过程:
CREATE PROCEDURE [dbo].[spGetcustomer]
@id int
AS
BEGIN
select * from custom where id = @id
END
@id int
AS
BEGIN
select * from custom where id = @id
END
现建一个根据部门名取部门ID的存储过程:
create PROCEDURE [dbo].[spGetdepartmenter]
@departname nvarchar(50)
AS
BEGIN
select * from department where departname = @departname
END
@departname nvarchar(50)
AS
BEGIN
select * from department where departname = @departname
END
再建两个根据ID删除数据的存储过程:
create PROCEDURE [dbo].[spDeletecustom]
@id int
AS
BEGIN
delete custom where id = @id
END
view sourceprint?CREATE PROCEDURE spdeletedepart
@id int
AS
BEGIN
delete department where id = @id
END
GO
@id int
AS
BEGIN
delete custom where id = @id
END
view sourceprint?CREATE PROCEDURE spdeletedepart
@id int
AS
BEGIN
delete department where id = @id
END
GO