杯壶自动切管折盒金工 pigcais
关注数: 5 粉丝数: 37 发帖数: 747 关注贴吧数: 1
通过SQL Server Profiler 跟踪到些事件 但数据表中没有相应的列 事件跟踪到的表名比实际的表名多出来,不知道这些是什么原因呢?事件跟踪到的insert语句: exec sp_executesql N'INSERT INTO "SD11102N_09ZB".."#saledetail" ("action","updateflag","invoiceid","itemno","goodsid","unitid","aprice","disc","price","quantity","unitprice","unitqty","taxrate","goodsamt","taxamt","amount","refertype","referbillid","referitemno","ispresent","returnqty","refercount","nprice","scorerate") VALUES (@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11,@P12,@P13,@P14,@P15,@P16,@P17,@P18,@P19,@P20,@P21,@P22,@P23,@P24)',N'@P1 int,@P2 varchar(77),@P3 int,@P4 int,@P5 int,@P6 int,@P7 numeric(18,6),@P8 numeric(18,6),@P9 numeric(18,6),@P10 numeric(18,6),@P11 numeric(18,6),@P12 numeric(18,6),@P13 numeric(18,6),@P14 numeric(18,6),@P15 numeric(18,6),@P16 numeric(18,6),@P17 int,@P18 int,@P19 int,@P20 varchar(1),@P21 numeric(18,6),@P22 int,@P23 numeric(18,6),@P24 numeric(18,6)',2,'11111111111111111111111111101000000000000010000000000001111111111111000100010',-1,-1,6330,6472,0.000000,100.000000,54000.000000,1.000000,54000.000000,1.000000,0.000000,54000.000000,0.000000,54000.000000,1,24283,1,'F',0.000000,0,54000.000000,1.000000 数据表 结构为: CREATE TABLE [dbo].[saledetail]( [invoiceid] [dbo].[t_keyid] NOT NULL, [itemno] [dbo].[t_keyid] NOT NULL, [goodsid] [dbo].[t_keyid] NOT NULL, [unitid] [dbo].[t_keyid] NOT NULL, [aprice] [dbo].[t_price] NOT NULL, [disc] [dbo].[t_disc] NOT NULL, [price] [dbo].[t_price] NOT NULL, [quantity] [dbo].[t_quantity] NOT NULL, [unitprice] [dbo].[t_price] NOT NULL, [unitqty] [dbo].[t_quantity] NOT NULL, [batchrefid] [dbo].[t_keyid] NULL, [batchcode] [varchar](32) NULL, [produceddate] [dbo].[t_date] NULL, [validdate] [dbo].[t_date] NULL, [taxrate] [dbo].[t_double] NOT NULL, [goodsamt] [dbo].[t_amount] NOT NULL, [taxamt] [dbo].[t_amount] NOT NULL, [amount] [dbo].[t_amount] NOT NULL, [userdef1] [varchar](64) NULL, [userdef2] [varchar](64) NULL, [userdef3] [varchar](64) NULL, [memo] [varchar](64) NULL, [refertype] [dbo].[t_integer] NULL, [referbillid] [dbo].[t_keyid] NULL, [referitemno] [dbo].[t_keyid] NULL, [ispresent] [dbo].[t_bool] NOT NULL, [returnqty] [dbo].[t_quantity] NOT NULL, [returnamt] [dbo].[t_amount] NOT NULL, [refercount] [dbo].[t_integer] NOT NULL, [nprice] [dbo].[t_price] NULL, [goodsaddress] [varchar](32) NULL, [userdef4] [varchar](64) NULL, [userdef5] [varchar](64) NULL, [userdef6] [varchar](64) NULL, [userdef7] [varchar](64) NULL, [userdef8] [varchar](64) NULL, [userdef9] [varchar](64) NULL, [userdef10] [varchar](64) NULL, [userdef11] [varchar](64) NULL, [userdef12] [varchar](64) NULL, [userdef13] [varchar](64) NULL, [userdef14] [varchar](64) NULL, [userdef15] [varchar](64) NULL, [scorerate] [dbo].[t_quantity] NOT NULL, [barcodeid] [dbo].[t_keyid] NULL, )
1 下一页