哪位大侠神仙围观一下，看看什么原因啊，50分啊～～～～～～～～～～～～～～～
alter proc P_TCC_INF_UseCaseQuery
as
begin
declare @opename varchar(200)
declare @tablename varchar(200)
declare @module_displayname varchar(200)
declare @projectidField varchar(200)
declare @keyField varchar(100)
declare @registerdatefield varchar(200)
declare @registernameField varchar(100)
declare @statusfield varchar(1000)
declare @sql varchar(8000)
declare @sid bigint
declare @cur cursor
create table #t(
TOpeName varchar(200),TtableName varchar(200),
TModule_DisplayName varchar(200),TprojectidField varchar(200),
TkeyField varchar(100),Tregisterdatefield varchar(200),
TregisternameField varchar(100),Tstaus varchar(1000)
)
set @cur = cursor
for
select OpeName,tableName,Module_DisplayName,projectidField,keyField,registerdatefield,
registernameField,statusfield from TCC_V_INF_UseCaseQuery
open @cur
fetch next from @cur into @OpeName,@tableName,@Module_DisplayName,
@projectidField,@keyField,@registerdatefield,@registernameField,@statusfield
while @@FETCH_STATUS=0
begin
set @sql = 'insert into #t (TprojectidField,TkeyField,Tregisterdatefield,TregisternameField,Tstaus)
select '+@projectidField+','+@keyField+',
'+@registerdatefield+','+@registernameField+','+@statusfield+' from ' +@tablename+ ' '
exec (@sql)
print(@sql)
fetch next from @cur into @OpeName,@tableName,@Module_DisplayName,@projectidField,
@keyField,@registerdatefield,@registernameField,@statusfield
end
close @cur
deallocate @cur
select * from #t
drop table #t
end
老是报错：消息 102，级别 15，状态 1，第 3 行 ',' 附近有语法错误。
分析一下什么原因啊，不甚感激
[解决办法]
我这边编译是通过的 不过没看你的逻辑。
[解决办法]
我估计还是exec (@sql) @sql里面的拼接有问题，你运行一下，把@sql的值复制出来看看。
[解决办法]
我仔细看了下，也在Management Studio 编译通过，没有报错信息
[解决办法]
set @sql = 'insert into #t (TprojectidField,TkeyField,Tregisterdatefield,TregisternameField,Tstaus) select '+@projectidField+','+@keyField+','+@registerdatefield+','+@registernameField+','+@statusfield+' from ' +@tablename+ ' 'exec (@sql)
