--===============定义游标,产生字段列表==========================declare @tablename VARCHAR(256)use adatabaseset @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 = @tablenameOPEN 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 tmpCursorPRINT @tempNameAll--===============定义游标,产生字段列表==========================