exec 执行问题,百思不得其解
etuo8 2006-06-13 05:40:27 declare @sort_id int
declare @sql_text varchar(8000)
select @sort_id = 15
select @sql_text = 'CREATE TABLE #ttb_bill_shortg (
[c_id] [varchar] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[c_sort] [int] IDENTITY ('+convert(char,@sort_id)+', 1) NOT NULL,
[c_adno] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[c_provider] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[c_gcode] [varchar] (13) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[c_subcode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[c_unit] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[c_pt_cost] [money] NULL ,
[c_price] [money] NULL ,
[c_tax_rate] [decimal](6, 2) NULL ,
[c_req_number] [decimal](12, 3) NULL ,
[c_number] [decimal](12, 3) NULL
) ON [PRIMARY]'
exec @sql_text
执行的时候提示服务器: 消息 203,级别 16,状态 2,行 18
名称 'CREATE TABLE #ttb_bill_shortg (
[c_id] [varchar] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[c_sort] [int] IDENTITY (15 , 1) NOT NULL,
[c_adno] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[c_provider] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[c_gcode] [varchar] (13) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[c_subcode] [varchar] (10...
select @sql_text 无法显示全部sql语句,谢谢各位多多帮忙