11 2018 档案
摘要：update a set a.AreaCode=(SUBSTRING(h.NAME,1,1)+'0'+SUBSTRING(h.NAME,2,1)+'0J') from T_BD_SmokeSensor a left join T_BD_Area b on a.AreaCode=b.AreaCode--系统区域表 left join [FuAnDB].[dbo].[ent_enterprise] ...
阅读全文
摘要：BEGIN TRAN Tran_Money --开始事务 DECLARE @tran_error int; SET @tran_error = 0; BEGIN TRY UPDATE tb_Money SET MyMoney = MyMoney - 30 WHERE Name = '刘备'; SET @tran_error = @tran_er...
阅读全文
