关于SQL SERVER的动态游标，怎么不对？(50分)

A

asaili

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-10-11

• #1

declare @doc as varchar(12)
declare @Tdate as varchar(12)
declare @Tlink as varchar(12)
declare @IntCheck as varchar(12)
Select @sql="FETCH ABSOLUTE -"+Convert(char,@PageSize,2)+" From DataCur into @doc,@Tdate,@Tlink,@IntCheck"
execute(@sql)
语法检查通过
执行时提示@doc没有定义

 

A

asaili

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-10-11

• #2

upp

 

A

asaili

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-10-11

• #3

谁能告诉我一个方法吗？

 

A

asaili

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-01

• #4

upp

 

Q

qingxi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-01

• #5

declare @doc as varchar(12)
declare @Tdate as varchar(12)
declare @Tlink as varchar(12)
declare @IntCheck as varchar(12)
Select @sql="FETCH ABSOLUTE -"+Convert(char,@PageSize,2)+" From DataCur into "+
'''+@doc+''',...
execute(@sql)
总之'号要加够

 

A

asaili

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-23

• #6

接受答案了.