set @NewsID=@@IDENTITY
print @NewsID --正常
set @sql='insert into '+@dbname+'.[dbo].[articleofchannel] (channelid,articlepageid) values('+Rtrim(@ChannelID)+','+Rtrim(@NewsID)+' )' --在这儿就出错了
print @sql
print @NewsID --正常
set @sql='insert into '+@dbname+'.[dbo].[articleofchannel] (channelid,articlepageid) values('+Rtrim(@ChannelID)+','+Rtrim(@NewsID)+' )' --在这儿就出错了
print @sql
set @NewsID=@@IDENTITY
print @NewsID --正常
set @sql='insert into '+@dbname+'.[dbo].[articleofchannel] (channelid,articlepageid) values('+Cast(@ChannelID As Varchar)+','+Cast(@NewsID As Varchar)+' )' --在这儿就出错了
print @sql
--需要先转换为 字符型,如:
set @sql='insert into '+@dbname+'.[dbo].[articleofchannel] (channelid,articlepageid)
values('+ cast(@ChannelID as varchar(100))+','+ cast(@NewsID as varchar(100))+' )' --在这儿就出错了
print @NewsID --正常
set @sql='insert into '+@dbname+'.[dbo].[articleofchannel] (channelid,articlepageid) values('+@ChannelID+','''+@NewsID+''' )' --在这儿就出错了
print @sql
也总是不行