njl_041x

摘要： 首先看一下数据结构表 1 IF(OBJECT_ID('tempdb..#tProduct')IS NOT NULL) 2 DROP TABLE #tProduct 3 SELECT * INTO #tProduct FROM( 4 SELECT 1 AS CatagoryID,1 AS ProductID,'aaa'AS ProductName 5 UNION 6 SELECT 1 AS CatagoryID,2 AS ProductID,'bbb'AS ProductName 7 UNION 8 SELECT 1 AS CatagoryID.. 阅读全文