users.sql

来自「登陆界面」· SQL 代码 · 共 29 行

create database book
use book

create table users
(
	userName varchar(20) primary key,
	userPwd varchar(20) not null
)

insert into users values('admin','admin')

create procedure checkUserName
@userName varchar(20)
as
select count(*) from users
where userName=@userName
go

create procedure insertUsers
@userName varchar(20),
@userPwd varchar(20)
as
insert into users values(@userName,@userPwd)
return
go

select * from users