ALTER proc [dbo].[Pro_Update]
(
@tablename nvarchar(50),
@titleid int
)
as
declare @table nvarchar(50)
declare @sql int
set @table = @tablename
set @sql = 'update ' + @table + ' set accessno = accessno + 1 where id =' + @titleid
exec(@sql)错误提示:
在将 nvarchar 值 'update frontInfo set accessno = accessno + 1 where id =' 转换成数据类型 int 时失败。 谢谢!!!!!
(
@tablename nvarchar(50),
@titleid int
)
as
declare @table nvarchar(50)
declare @sql int
set @table = @tablename
set @sql = 'update ' + @table + ' set accessno = accessno + 1 where id =' + @titleid
exec(@sql)错误提示:
在将 nvarchar 值 'update frontInfo set accessno = accessno + 1 where id =' 转换成数据类型 int 时失败。 谢谢!!!!!
(
@tablename nvarchar(50),
@titleid int
)
as
declare @sql nvarchar(4000)
set @sql = 'update ' + @tablename + ' set accessno = accessno + 1 where id =' + @titleid
exec(@sql)