CREATE PROCEDURE [dbo].[createSurveyTable]
@strTableName nvarchar(20)
AS
declare @sql varchar(8000)set @sql='CREATE TABLE dbo.'+@strTableName+' (
sec_id int not null,
sur_id int not null,
sec_desc nvarchar(1000) null,
is_required tinyint not null default 1,
finish_st_value AS (power(2,[order_no])),
order_no int not null default 1
)'exec(@sql)GO
@strTableName nvarchar(20)
AS
declare @sql varchar(8000)set @sql='CREATE TABLE dbo.'+@strTableName+' (
sec_id int not null,
sur_id int not null,
sec_desc nvarchar(1000) null,
is_required tinyint not null default 1,
finish_st_value AS (power(2,[order_no])),
order_no int not null default 1
)'exec(@sql)GO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货