聊天室 asp.net

if exists(select * from Sysdatabases where name='chat') drop database chat go create database chat on ( name='chat_dat', filename='F:\ASP.NET\聊天室\datachat.mdf', size=5mb, maxsize=unlimited, filegrowth=5% ) log on ( name='chat_log', filename='F:\ASP.NET\聊天室\datachat.ldf', size=1mb, maxsize=unlimited, filegrowth=1% ) go use chat if exists(select * from sysobjects where name='UserInfo') drop table UserIfo go if exists(select * from sysobjects where name='ChatContent') drop table ChatContent go create table UserInfo ( UserId int identity(1,1) primary key not null, NickName varchar(20) not null, UserName varchar(20), [Password] varchar(20) not null, Birthday datetime , Gender int not null, LastLoginTime datetime not null, LastLoginIp varchar(20)not null, status int not null, Type int not null, FaceUrl varchar(20), Remark varchar(20) ) insert into userinfo values('xsf','xsf','111','1999-9-9',1,'1999-9-9','127.0.0.1',1,1,'adf','adf') select * from userinfo create table ChatContent ( ChatContentId int identity(1,1) primary key not null, SenderId int not null, ReceiverId int not null, SenderName varchar(20), ReceiverName varchar(20), SendTime datetime not null, Content text not null, type int not null ) drop proc InsertUserInfo create proc InsertUserInfo @NickName varchar(20), @UserName varchar(20), @Password varchar(20), @Birthday datetime , @Gender int , @LastLoginTime datetime , @LastLoginIp varchar(20), @status int , @Type int , @FaceUrl varchar(20), @Remark varchar(20) as declare @count int select @count=count(*) from UserInfo where NickName=@NickName if @count>0 raiserror('昵称已经被注册',16,1); else begin insert into UserInfo values(@NickName,@UserName,@Password,@Birthday,@Gender,@LastLoginTime,@LastLoginIp,@status,@Type,@FaceUrl,@Remark) end go CREATE PROCEDURE SelectUserInfo @UserId int, @NickName varchar(22), @PassWord varchar(22), @Gender int as declare @sql nvarchar(500) set @sql='select * from UserInfo where 1=1' if @UserId!=-1 set @sql=@sql+' and UserId='+@UserId if @NickName!='' set @sql=@sql+' and NickName='''+@NickName+'''' if @Gender!=-1 set @sql=@sql+' and Gender='+@Gender if @PassWord!='' set @sql=@sql+' and PassWord='''+@PassWord+'''' execute sp_executesql @sql go EXECUTE SelectUserInfo -1,'xsf','111',-1 --drop proc SelectUserInfo