SELECT @N=MAX(LEN(F0080)) FROM KLDB.DBO.OTH_D_NEWS--临时表,ID最大值为相关股票字段最大长度
SET @SQL='SELECT TOP '+CONVERT(VARCHAR(10),@N)+' ID = IDENTITY(INT,1,1)
INTO # FROM SYSCOLUMNS A, SYSCOLUMNS B' EXECUTE SP_EXECUTESQL @SQLSELECT * FROM #
---------------------------------------
服务器: 消息 208,级别 16,状态 1,过程 P_GENERATE_TB8002,行 20
对象名 '#' 无效。应该如何处理?
SET @SQL='SELECT TOP '+CONVERT(VARCHAR(10),@N)+' ID = IDENTITY(INT,1,1)
INTO # FROM SYSCOLUMNS A, SYSCOLUMNS B' EXECUTE SP_EXECUTESQL @SQLSELECT * FROM #
---------------------------------------
服务器: 消息 208,级别 16,状态 1,过程 P_GENERATE_TB8002,行 20
对象名 '#' 无效。应该如何处理?
SET @SQL='SELECT TOP '+CONVERT(VARCHAR(10),@N)+' ID = IDENTITY(INT,1,1)
INTO #a FROM SYSCOLUMNS A, SYSCOLUMNS B' EXECUTE SP_EXECUTESQL @SQLSELECT * FROM #a
临时表也要表名啊- -#
SET @SQL='SELECT TOP '+CONVERT(VARCHAR(10),@N)+' ID = IDENTITY(INT,1,1)
INTO ##T FROM SYSCOLUMNS A, SYSCOLUMNS B'EXECUTE SP_EXECUTESQL @SQLSELECT * FROM ##T