博文
sql高级编程(2009-06-01 18:46:00)
摘要：今天上班闲着无事，写了个SQL例子，以供参考
1、--创建一个数据库create database test_danliu2、--创建一个表CREATE TABLE [dbo].[testuser]( [ID] [int] NOT NULL, [username] [char](10) COLLATE Chinese_PRC_CI_AS NOT NULL, [usersex] [char](2) COLLATE Chinese_PRC_CI_AS NULL, [address] [char](100) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_testuser] PRIMARY KEY CLUSTERED ( [ID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]3、--创建不带参的存储过程create procedure [dbo].[table_testuser]asdeclare @i intset @i=0while(@i<10)beginInsert into testuser values(@i,'we','女','安徽')set @i=@i+1end4、--创建含不含输出参数的存储过程create procedure [dbo].[checktestuser] @parausername ......