Create table:
CREATE TABLE [BookUser] ( [UserID] [Int] IDENTITY (1, 1) NOT NULL, [UserName] [Varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL, [Title] [Nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL, [Guid] [Uniqueidentifier] NOT NULL CONSTRAINT [DF_BookUser_Guid] DEFAULT(newid ()), [BirthDate] [Datetime] NOT NULL, [Description] [Ntext] COLLATE Chinese_PRC_CI_AS NOT NULL, [Photo] [Image] NULL, [Other] [Varchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_BookUser_Other] DEFAULT ('default'), CONSTRAINT [PK_BookUser] PRIMARY KEY CLUSTERED ( [UserID] ) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO |
Create a stored procedure:
CREATE PROCEDURE InsertUser @ UserName varchar (50), @ Title varchar (255), @ Guid uniqueidentifier, @ BirthDate DateTime, @ Description ntext, @ Photo image, @ Other nvarchar (50), @ UserID int output As Set NOCOUNT ON If Exists (select UserID from BookUser Where UserName = @ UserName) RETURN 0 ELSE Begin INSERT INTO BookUser (UserName, Title, Guid, BirthDate, Description, Photo, Other) VALUES (@UserName, @ Title, @ Guid, @ BirthDate, @ Description, @ Photo, @ Other) SET @ UserID = @ @ IDENTITY RETURN 1 End GO |
No comments:
Post a Comment