CREATE PROCEDURE updatanews
@lm nvarchar(20),
@title nvarchar(50),
@titlecoloc nchar(7),
@bj nvarchar(20),
@ly nvarchar(30),
@content ntext,
@tableName nvarchar(20),
@id int
AS
begin
declare @sql Nvarchar (4000)
set @sql='updata ' + @tableName + ' set
lm =@lm,
title= @title ,
titlecoloc =@titlecoloc,
bj =@bj,
ly = @ly ,
content = @content
where id=@id'
exec sp_executesql @sql,N'
@lm nvarchar(20),
@title nvarchar(50),
@titlecoloc nchar(7),
@bj nvarchar(20),
@ly nvarchar(30),
@content ntext,
@tableName nvarchar(20),
@id int',
@lm ,
@title ,
@titlecoloc ,
@bj ,
@ly ,
@content ,
@tableName ,
@id
end
GO
这样子有没有错呀
@lm nvarchar(20),
@title nvarchar(50),
@titlecoloc nchar(7),
@bj nvarchar(20),
@ly nvarchar(30),
@content ntext,
@tableName nvarchar(20),
@id int
AS
begin
declare @sql Nvarchar (4000)
set @sql='updata ' + @tableName + ' set
lm =@lm,
title= @title ,
titlecoloc =@titlecoloc,
bj =@bj,
ly = @ly ,
content = @content
where id=@id'
exec sp_executesql @sql,N'
@lm nvarchar(20),
@title nvarchar(50),
@titlecoloc nchar(7),
@bj nvarchar(20),
@ly nvarchar(30),
@content ntext,
@tableName nvarchar(20),
@id int',
@lm ,
@title ,
@titlecoloc ,
@bj ,
@ly ,
@content ,
@tableName ,
@id
end
GO
这样子有没有错呀
参考
SELECT @ptrval = TEXTPTR(pr_info)
FROM pub_info pr, publishers p
WHERE p.pub_id = pr.pub_id
AND p.pub_name = 'New Moon Books'
UPDATETEXT pub_info.pr_info @ptrval 88 1 'b'
能帮我说说这个是什么意思不哟,太菜了,看不明白