1、如何查询出表M_DRAW以billid为标识从第4条记录开始到第10条记录 6=10-4
select top 6 * from M_DRAW where billid not in (select top 4 billid from M_DRAW order by billid asc) 备注:标识值以不重为准!
2、提示主键、单号、编码相同的解决方法:打开表:KEYVALUETABLE!然后改对应单据的数据表的数字,只可大不可小!没有就直接在最后添加再加数据!
insert into "WEB2009_10-20-(好)".dbo.GOODS select * from "WEB2009_1026".dbo.GOODS where GOODSID = 200162