摘要:
1、update a inner join b on a.id=b.id set a.name=b.name where ...2、update table1 set a.name = b.name from table1 a inner join table2 b on a.id =b.id wh... 阅读全文
摘要:
IF OBJECT_ID('tempdb..#TB_TEMP_SPACE') IS NOT NULL DROP TABLE #TB_TEMP_SPACEGOCREATE TABLE #TB_TEMP_SPACE( NAME VARCHAR(500) ,ROWS INT ,RESER... 阅读全文