【求助】把数据添加到临时表出错
代码如下:
declare @strSQL varchar(100)
CREATE TABLE #tempTable(ID int identity(1,1),NID int)
SET @strSQL = 'INSERT INTO #tempTable(NID) SELECT TOP 20 fID FROM [tOA] SELECT T1.*,T2.* FROM [tOA] AS T1, #tempTable AS T2 WHERE T1.fID = T2.NID AND T2.ID > 0 AND T2.ID <= 10 ORDER BY T2.ID DROP TABLE #tempTable'
EXEC (@strSQL)
如果是这样就不会出错:
CREATE TABLE #tempTable(ID int identity(1,1),NID int)
INSERT INTO #tempTable(NID) SELECT TOP 20 fID FROM [tOA] SELECT T1.*,T2.* FROM [tOA] AS T1, #tempTable AS T2 WHERE T1.fID = T2.NID AND T2.ID > 0 AND T2.ID <= 10 ORDER BY T2.ID DROP TABLE #tempTable
有谁知道为什么吗?