SQL Server 2005 学习中 00001

--创建数据库
create database chjyy
--创建表
create table UsersInfo
(UserName varchar(8) primary key not null,
 Password varchar(18) not null,
 levelis tinyint
);
--删除表
drop table UsersInfo
--为表插入数据
insert into UsersInfo
values('yuwen','111111',0);
insert into UsersInfo
values('guest','000000',1);
--查看表中数据
select * from UsersInfo
--创建存储过程-检验用户名是否存在
create procedure CheckUserName
@UserName varchar(8)
as
select count(*) from UsersInfo
where UserName=@UserName
go
--创建存储过程-检验插入数据是否合法
create procedure InsertUserInfo
@UserName varchar(8),
@Password varchar(18),
@Levelis tinyint
as
insert into UsersInfo values(@UserName,@Password,@Levelis)
go