if Exists(Select name From sysobjects Where name='CheckExistMonitor' And type='P')
-- 删除存储过程
Drop Procedure CheckExistMonitor
Go
create procedure CheckExistMonitor
as
begin
declare @MonitorExists int
select @MonitorExists=count('Allproject') from sp_databases --这句有问题
if @MonitorExists<1
begin
create database Allproject
use Allproject --最重要的问题
go
create table ProjectInfo --项目信息表
(
ProjectName varchar(50) primary key,
ProjectNote varchar(150) null,
CreateTime datetime not null,
CreatePlace varchar(50) null,
CreatePerson varchar(25) not null,
ApplyMachine varchar(25) null
)
create table UserInfo --用户信息表
(
UserName varchar(25) primary key,
UserPwd varchar(25) not null,
UserRole varchar(10) not null check(UserRole in('管理人员','普通人员')) default '普通人员',
UserPermission varchar(400) not null,
CreateTime datetime not null,
CreatePlace varchar(50) null
)
create table UserLog --用户日志表
(
UserName varchar(25) primary key,
LoginTime datetime not null,
ExitTime datetime null,
)
end
end
go
麻烦各位大神修改下,感激涕零啊
