|
CREATE PROCEDURE dbo.USP_GET_BOARD_LIST
@LISTCNT INT,
@PAGENUM INT,
@SEARCH VARCHAR(255)
AS
BEGIN
DECLARE @SQL NVARCHAR(1500)
DECLARE @STARTPOINT INT
DECLARE @ENDPOINT INT
SET @STARTPOINT = @LISTCNT * (@PAGENUM - 1) + 1
SET @ENDPOINT = @LISTCNT * @PAGENUM
SET @SQL = 'SELECT IDX=IDENTITY(10), SEQ, TITLE, WRITEDATE, READCOUNT INTO #TMP001 FROM NOTICE'
IF @SEARCH IS NOT NULL
SET @SQL = @SQL + ' WHERE ' + @SEARCH
SET @SQL = @SQL + ' ORDER BY SEQ DESC'
EXEC (@SQL)
SET ROWCOUNT @LISTCNT
SET @SQL = 'SELECT SEQ, TITLE, WRITEDATE, READCOUNT FROM #TMP001 WHERE IDX BETWEEN ' + CONVERT(VARCHAR(8),@STARTPOINT) + ' AND ' + CONVERT(VARCHAR(8),@ENDPOINT)
EXEC (@SQL)
DROP TABLE #TMP001
END
이 프로시져를 실행시키면 아래와 같은 오류가 생깁니다..해결책 좀 알려주세요...완전 삽질하고 있어요.. OTL
[DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]#TMP001 not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
|
