Query is as follows:
查询如下:
create TABLE tbl_temp (
[ref] numeric(18),
[item_code] varchar(50),
[item_desc] nvarchar(150),
[Qty] smallint) PRIMARY KEY (ref, item_code))
create TABLE tblQuery is as follows:
查询如下:
create TABLE tbl_temp (
[ref] numeric(18),
[item_code] varchar(50),
[item_desc] nvarchar(150),
[Qty] smallint) PRIMARY KEY (ref, item_code))
create TABLE tbl