摘要:BEGIN TRAN Tran_Money --开始事务 DECLARE @tran_error int; SET @tran_error = 0; BEGIN TRY --要执行的插入、更新SQL语句 SET @tran_error = @tran_error + @@ERROR; END TRY
阅读全文
posted @ 2020-05-13 18:18
|
|||
05 2020 档案
摘要:BEGIN TRAN Tran_Money --开始事务 DECLARE @tran_error int; SET @tran_error = 0; BEGIN TRY --要执行的插入、更新SQL语句 SET @tran_error = @tran_error + @@ERROR; END TRY
阅读全文
posted @ 2020-05-13 18:18
摘要:表结构 功能 SQL Server Access 表结构 功能 用表B的数据(mc列)更新表A的mc列 SQL Server update A SET A.mc = b.mc FROM A ,B WHERE A.bmbh = B.bmbh and A.xmbh = B.xmbh; Access up
阅读全文
posted @ 2020-05-07 11:13
|
|||