两个问题请教
1、这句SQL在SQL-Server中能通,为何在ACCESS中不行
Update x1
Set x1.lngQuanLeft = 0, x1.curLastIn = x2.dblPrice, x1.curLastOut = x2.dblPrice,
x1.curLastSale=x2.dblPrice,x1.curLastCost =x2.dblPrice
FROM TB_PART_STRU x1, TB_DICT_PT x2 WHERE x1.lngPTID = x2.Id2、软件所带ACCESS数据库如何比较好地进行加密如何加密?
1、这句SQL在SQL-Server中能通,为何在ACCESS中不行
Update x1
Set x1.lngQuanLeft = 0, x1.curLastIn = x2.dblPrice, x1.curLastOut = x2.dblPrice,
x1.curLastSale=x2.dblPrice,x1.curLastCost =x2.dblPrice
FROM TB_PART_STRU x1, TB_DICT_PT x2 WHERE x1.lngPTID = x2.Id2、软件所带ACCESS数据库如何比较好地进行加密如何加密?
Set x1.lngQuanLeft = 0, x1.curLastIn = x2.dblPrice, x1.curLastOut = x2.dblPrice,
x1.curLastSale=x2.dblPrice,x1.curLastCost =x2.dblPrice
UPDATE 表
SET新值
WHERE准则;