--
===============定义游标,产生字段列表==========================
declare @tablename VARCHAR ( 256 )
use adatabase
set @tablename = ' tablename '
DECLARE @tempName VARCHAR ( 256 ), @tempNameall VARCHAR ( 1024 )
SET @tempNameAll = ''
DECLARE tmpCursor CURSOR
FOR
SELECT SYSCOLUMNS.name FROM SYSCOLUMNS,SYSOBJECTS
WHERE SYSCOLUMNS.ID = SYSOBJECTS.ID and SYSOBJECTS.name = @tablename
OPEN tmpCursor
FETCH NEXT FROM tmpCursor INTO @tempName
WHILE @@FETCH_STATUS = 0
BEGIN
SET @tempNameAll = @tempNameall + ' , ' +char(13)+ @tablename + '.' + @tempName
FETCH NEXT FROM tmpCursor INTO @tempName
END
CLOSE tmpCursor
DEALLOCATE tmpCursor
PRINT @tempNameAll
-- ===============定义游标,产生字段列表==========================
declare @tablename VARCHAR ( 256 )
use adatabase
set @tablename = ' tablename '
DECLARE @tempName VARCHAR ( 256 ), @tempNameall VARCHAR ( 1024 )
SET @tempNameAll = ''
DECLARE tmpCursor CURSOR
FOR
SELECT SYSCOLUMNS.name FROM SYSCOLUMNS,SYSOBJECTS
WHERE SYSCOLUMNS.ID = SYSOBJECTS.ID and SYSOBJECTS.name = @tablename
OPEN tmpCursor
FETCH NEXT FROM tmpCursor INTO @tempName
WHILE @@FETCH_STATUS = 0
BEGIN
SET @tempNameAll = @tempNameall + ' , ' +char(13)+ @tablename + '.' + @tempName
FETCH NEXT FROM tmpCursor INTO @tempName
END
CLOSE tmpCursor
DEALLOCATE tmpCursor
PRINT @tempNameAll
-- ===============定义游标,产生字段列表==========================