摘要： USE wms;--> 测试数据：#taIF OBJECT_ID('TEMPDB.DBO.#ta') IS NOT NULL DROP TABLE #taGO CREATE TABLE #ta([name] VARCHAR(10))INSERT #taSELECT 'a' UNION ALLSELECT 'b' UNION ALLSELECT 'd'--> 测试数据：#tbIF OBJECT_ID('TEMPDB.DBO.#tb') IS NOT NULL DROP TABLE #tbGO CREATE 阅读全文