procedure 创建模板

/******************************************************************************** * FILE NAME : sp_DisplayUserName_sel1.prc *-------------------------------------------------------------------------------- * CREATE : 2009/11/23 COM ThinkinGall * COMMENT : 用户信息取得处理 *-------------------------------------------------------------------------------- * << UPDATE LIST >> * --DATE-- ----NAME---- -------------COMMENT------------ * ******************************************************************************/ IF EXISTS (SELECT name FROM sysobjects WHERE type = 'P' AND name = 'sp_DisplayUserName_sel1') BEGIN DROP PROCEDURE sp_DisplayUserName_sel1 END GO CREATE PROCEDURE sp_DisplayUserName_sel1 ( @_UserID CHAR(10) -- 用户ID ) AS BEGIN -- 用户信息取得处理 SELECT Eusr_UserID, Eusr_UserName, Eusr_UserGender FROM ENT_USER WHERE Eusr_UserID = @_UserID END GO GRANT EXEC ON sp_DisplayUserName_sel1 TO PUBLIC GO

 

--CREATE DATABASE [Aukey] ON  PRIMARY
--( NAME = N'Aukey', FILENAME = N'D:/DataBase/Aukey.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
-- LOG ON
--( NAME = N'Aukey_log', FILENAME = N'D:/DataBase/Aukey_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
--GO
--USE [Aukey]
--GO
--CREATE TABLE [dbo].[ENT_User](
-- [Eusr_UserID] [nchar](10) COLLATE Chinese_PRC_CI_AS NOT NULL,
-- [Eusr_UserName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
-- [Eusr_UserGender] [tinyint] NULL,
-- CONSTRAINT [PK_ENT_User] PRIMARY KEY CLUSTERED
--(
-- [ENT_UserID] ASC
--)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
--) ON [PRIMARY]
--insert into ENT_User(Eusr_UserID,Eusr_UserName,Eusr_UserGender) values ('1000000000','Admin',1)
--insert into ENT_User(Eusr_UserID,Eusr_UserName,Eusr_UserGender) values ('1000000001','xuyeding',1)
--insert into ENT_User(Eusr_UserID,Eusr_UserName,Eusr_UserGender) values ('1000000002','obama',0)