必须声明标量变量 "@CurSorVar"。--游标变量:
--1.先声明游标,然后声明游标变量,然后使用SET命名把游标赋值给游标变量:
Declare TestCursor scroll CurSor
For
Select * From Books order by Count desc
Declare @CurSorVar CurSor
SET @CurSorVar=TestCursor
Open @CurSorVar Fetch next From @CurSorVar
Fetch next From TestCursor
Fetch prior From TestCursor
Deallocate TestCursor
--1.先声明游标,然后声明游标变量,然后使用SET命名把游标赋值给游标变量:
Declare TestCursor scroll CurSor
For
Select * From Books order by Count desc
Declare @CurSorVar CurSor
SET @CurSorVar=TestCursor
Open @CurSorVar Fetch next From @CurSorVar
Fetch next From TestCursor
Fetch prior From TestCursor
Deallocate TestCursor
1.declare @name varchar(30) = 'aaaa'
print @name
2.declare @name varchar(30) = 'aaaa'
go
print @name
1可以执行,而2由于声明与使用分开,就会报错