企业内网与办公自动化（此版本已过期，请下载最新版）

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[book_bookSecurity]( [id] [int] IDENTITY(1,1) NOT NULL, [bookid] [int] NULL, [roleType] [int] NULL, [roles] [nvarchar](50) NULL, CONSTRAINT [PK_book_bookSecurity] PRIMARY KEY CLUSTERED ( [id] ASC ) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[sf_title]( [id] [int] IDENTITY(1,1) NOT NULL, [title] [nvarchar](50) NULL, [description] [nvarchar](100) NULL, CONSTRAINT [PK_sf_title] PRIMARY KEY CLUSTERED ( [id] ASC ) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[book_books]( [BookId] [int] IDENTITY(1,1) NOT NULL, [UserName] [nvarchar](50) NULL, [CreateDate] [datetime] NULL, [StartDate] [datetime] NULL, [EndDate] [datetime] NULL, [BookType] [nvarchar](50) NULL, [BookName] [nvarchar](50) NULL, [Status] [int] NULL, [IsClosed] [int] NULL, [dest] [nvarchar](100) NULL, [note] [nvarchar](500) NULL, CONSTRAINT [PK_book_books] PRIMARY KEY CLUSTERED ( [BookId] ASC ) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[book_AddBook] ( @UserName nvarchar(50), @CreateDate DateTime, @StartDate DateTime, @EndDate DateTime, @BookType nvarchar(100), @BookName nvarchar(100), @Status int, @IsClosed int, @dest nvarchar(200), @note nvarchar(500) ) AS Insert Into book_Books ( Username,createdate,startDate,enddate,booktype,bookname,status,isclosed,dest,note ) values( @Username,getdate(),@startdate,@enddate,@booktype,@bookname,@status,@isclosed,@dest,@note ) RETURN GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[book_GetBookByBookName] ( @bookName nvarchar(100) ) AS Select * from book_books where bookName=@bookName RETURN GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO Create PROCEDURE [dbo].[book_GetBookById] ( @bookId int ) AS Select * from book_books where bookid=@bookid RETURN