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(varchar,@sort_id)+', 1) NOT NULL, -----char改成varchar
[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
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(varchar,@sort_id)+', 1) NOT NULL, -----char改成varchar
[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
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)