存储过程检测用户名是否重户
create proc checklogin
@username nchar(20),
@pwd nchar(20),
@hasrow int output
as
select @hasrow=count(*) from users where username=@username and pwd=@pwd
GO
存储过程写入数据
create proc adduser
@username nchar(20),
@pwd nchar(20)
as
begin
insert into users (username,pwd)values(@username,@p
类别: 学习笔记 查看评论
文章来源: http://hi.baidu.com/honghu3000/blog/item/99a1b473f551831b8701b0be.html