出错的代码如下:
Declare @ChartName varchar(128)
Declare @Tagname varchar(64)
Declare @Query nvarchar(3000)
Declare @filename varchar Declare cursor_Query cursor For Select [Chart Name] from GCS Open cursor_Query
fetch next from cursor_Query into @ChartName
while @@fetch_status = 0
Begin
select @filename = @Chartnameselect @Query = 'bcp "select * from dbo.spc_ChartDataYear where ChartName = @ChartName order by DataTmst " queryout E:\GCSData\'+ @ChartName +'.xls -c -S"c01q57" -U"Tanadm" -P"Whisper01"' 系统提示:
SQLState = 37000, NativeError = 137
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]必须声明变量 '@ChartName'。
SQLState = 37000, NativeError = 8180
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]未能准备语句。这里我使用了游标,其实我是有声明了变量ChartName的,如果我把“where ChartName = @ChartName ”这个条件拿掉,运行就没有问题,现在请教一下如何解决这个问题?非常感谢!
Declare @ChartName varchar(128)
Declare @Tagname varchar(64)
Declare @Query nvarchar(3000)
Declare @filename varchar Declare cursor_Query cursor For Select [Chart Name] from GCS Open cursor_Query
fetch next from cursor_Query into @ChartName
while @@fetch_status = 0
Begin
select @filename = @Chartnameselect @Query = 'bcp "select * from dbo.spc_ChartDataYear where ChartName = @ChartName order by DataTmst " queryout E:\GCSData\'+ @ChartName +'.xls -c -S"c01q57" -U"Tanadm" -P"Whisper01"' 系统提示:
SQLState = 37000, NativeError = 137
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]必须声明变量 '@ChartName'。
SQLState = 37000, NativeError = 8180
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]未能准备语句。这里我使用了游标,其实我是有声明了变量ChartName的,如果我把“where ChartName = @ChartName ”这个条件拿掉,运行就没有问题,现在请教一下如何解决这个问题?非常感谢!
select @Query = 'bcp "select * from dbo.spc_ChartDataYear where ChartName = '+@ChartName+' order by DataTmst " queryout E:\GCSData\'+ @ChartName +'.xls -c -S"c01q57" -U"Tanadm" -P"Whisper01"'