数据库存储语句 找错并指正

来源：百度知道 编辑：UC知道 时间：2024/07/05 09:08:20
RT：(我对存储语句了解不多)
create procedure [dbo].[spCheckedNoteBookMainForIDs]
(
@ids nvarchar(600)
)
as
declare @tempsql nvarchar(700)
begin
set @tempsql = 'update tNoteBookMain set IsChecked=1 where id in(' +@ids + ')'; //怎么解释？？？
execute (@tempsql);
end
---------------------
create procedure [dbo].[spDeleteNoteBookMainForIDs]
(
@ids nvarchar(600)
)
as
declare @tempsql nvarchar(700)
begin
set @tempsql = "delete from tNoteBookMain where id in(' + @ids + ')";
execute (@tempsql);
end
---------------------
create procedure [dbo].[spNoteBookMainCheckedSelectCommand]
(
@isChecked bit
@id int
)
as
set nocount on;
select ID,Title,Body,UserName,CreateDate,IPAddress,Email,IsChecked,ReplyCount from tNoteBookMain where(IsChecked=@isChecked) and ID=@id

错误信息：
消息 1

create procedure [dbo].[spCheckedNoteBookMainForIDs]
(
@ids nvarchar(600)
)
as
declare @tempsql nvarchar(700)
begin
set @tempsql = 'update tNoteBookMain set IsChecked=1 where id in(' +@ids + ')'--; //怎么解释？？？
--生成SQL语句, @ids是条件
execute (@tempsql) --这是执行查询;
end
---------------------
go
create procedure [dbo].[spDeleteNoteBookMainForIDs]
(
@ids nvarchar(600)
)
as
declare @tempsql nvarchar(700)
begin
set @tempsql = "delete from tNoteBookMain where id in(' + @ids + ')"--;
execute (@tempsql)--;
end
---------------------
go
create procedure [dbo].[spNoteBookMainCheckedSelectCommand]
(
@isChecked bit ,
@id int
)
as
set nocount on;
select ID,Title,Body,UserName,CreateDate,IPAddress,Email,IsChecked,ReplyCount from tNoteBookMain where(IsChecked=@isChecked) and ID=@id