實(shí)現(xiàn)SQLSERVER動(dòng)態(tài)游標(biāo)的方法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
實(shí)現(xiàn)SQLSERVER動(dòng)態(tài)游標(biāo)的方法2：
exec(’
declare curOne cursor global
for’ + @aSql)
open curOne
fetch curOne
實(shí)現(xiàn)SQLSERVER動(dòng)態(tài)游標(biāo)的方法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
您現(xiàn)在的位置：首頁(yè)--數(shù)據(jù)庫(kù)--SQL Server--瀏覽文章
3種實(shí)現(xiàn)SQLSERVER動(dòng)態(tài)游標(biāo)的方法
點(diǎn)擊:216 發(fā)布日期：2008-1-12 12:39:08 進(jìn)入論壇
DEALLOCATE cuTemp
|
