sqlserver用存储过程建表

发布时间：2020-12-12 14:24:51 所属栏目：MsSql教程来源：网络整理

导读：ALTER PROCEDURE [dbo].[new_Friend]? ?@count ?varchar(100) --参数 AS BEGIN declare @sql varchar(2000)--建表sql语句 set @sql=' CREATE TABLE [dbo].[tb_Friend_'+@count+']( [ID] [int] IDENTITY(1,1) NOT NULL,[UserName] [varchar](30) COLLATE Chin

ALTER PROCEDURE [dbo].[new_Friend]? ?@count ?varchar(100) --参数 AS BEGIN declare @sql varchar(2000)--建表sql语句 set @sql=' CREATE TABLE [dbo].[tb_Friend_'+@count+']( [ID] [int] IDENTITY(1,1) NOT NULL,[UserName] [varchar](30) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_tb_Friend_'+@count+'_UserName] ?DEFAULT (''32''),?CONSTRAINT [PK_tb_Friend_'+@count+'] PRIMARY KEY CLUSTERED? ( [ID] ASC )WITH (PAD_INDEX ?= OFF,STATISTICS_NORECOMPUTE ?= OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS ?= ON,ALLOW_PAGE_LOCKS ?= ON) ON [PRIMARY] ) ON [PRIMARY] ' ?exec (@sql)--执行 END EXEC [new_Friend][65]--调用

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!