实现SQLSERVER动态游标的方法1:
CREATE TABLE #tabTmp(id int) INSERT #tabTmp EXECUTE(’SELECT id FROM ’+@TableName) declare curOne cursor for SELECT id FROM #tabTmp open curOne FETCH NEXT from curOne into @ID
实现SQLSERVER动态游标的方法2: exec(’ declare curOne cursor global for’ + @aSql) open curOne fetch curOne
实现SQLSERVER动态游标的方法3: declare @sql varchar(2000), @typefield varchar(100), @tablename varchar(255), @name varchar(100) select @typefield = ’’name’’,@tablename = ’’sysobjects’’ set @sql = ’’ declare cuTemp cursor for ’’ +’’ SELECT DISTINCT ’’+@typefield + ’’ FROM ’’ + @tablename exec (@sql) open cuTemp fetch cuTemp into @name while (@@fetch_status=0) begin print @name fetch cuTemp into @name end close cuTemp
您现在的位置:首页--数据库--SQL Server--浏览文章 3种实现SQLSERVER动态游标的方法 点击:216 发布日期:2008-1-12 12:39:08 进入论坛
DEALLOCATE cuTemp
|