--使用存储过程实现增删改查
--增加
create proc usp_UserAdd
@uname nvarchar(20),
@upass nvarchar(20),
@age int
as
begin
insert into T_Users(UserName,PassWord,Age) values(@uname,@upass,@age)
end
--增加
create proc usp_UserAdd
@uname nvarchar(20),
@upass nvarchar(20),
@age int
as
begin
insert into T_Users(UserName,PassWord,Age) values(@uname,@upass,@age)
end
exec usp_UserAdd @uname=admin,@upass=123,@age=23
----删除
--create proc usp_Deleted
--@userid int
--as
--begin
-- delete from T_Users where UserId = @userid
--end
--go
--exec usp_Deleted @userid = 57