SqlServer delphi执行存储过程报错

测试积点老人 · 发表于 2020-3-11 11:40:42

@id int,
[url=home.php?mod=space&uid=26120]@content[/url] image ,
@gamename varchar(200)
AS
BEGIN
declare @temp varbinary(500)
declare @tmpid int =-1
declare @sql varchar(500)
print @tmpid
select @tmpid=id from dbo.ActivityPlayers where <a href="mailto:id=@id">id=@id</a>
print @tmpid
if @tmpid =-1
begin
insert into dbo.ActivityPlayers (id) values(@id)
end
set @temp=CONVERT(varbinary(500),@content)
set @sql='update dbo.ActivityPlayers set <a href="mailto:'+@gamename+'='+CONVERT(varchar(1000">'+@gamename+'='+CONVERT(varchar(1000</a>), @temp)+' where id='+convert(varchar(20),@id)
print @sql
exec(@sql)
END