Create PROCEDURE MyTest
@ids varchar(1000),
@commend int
AS
BEGIN
declare @index int
declare @a_id int
declare @s_id varchar(20)
set @ids = @ids + ','
set @index = charindex(',', @ids)
while (@index > 0)
begin
set @s_id = left(@ids, @index - 1)
set @a_id = convert(int, ltrim(rtrim(@s_id)))
update Commend set commend = @commend
where id = @a_id
if @@rowcount <= 0
begin
insert into Commend(id, commend)
values (@a_id, @commend)
end
set @ids = Right(@ids, len(@ids) - len(@s_id) - 1)
set @index = charindex(',', @ids)
end
return 1
END
GO
---------------
DECLARE @return_value intEXEC @return_value = [dbo].[MyTest]
@ids = N'1,2,3',
@commend = 4SELECT 'Return Value' = @return_value
@ids varchar(1000),
@commend int
AS
BEGIN
declare @index int
declare @a_id int
declare @s_id varchar(20)
set @ids = @ids + ','
set @index = charindex(',', @ids)
while (@index > 0)
begin
set @s_id = left(@ids, @index - 1)
set @a_id = convert(int, ltrim(rtrim(@s_id)))
update Commend set commend = @commend
where id = @a_id
if @@rowcount <= 0
begin
insert into Commend(id, commend)
values (@a_id, @commend)
end
set @ids = Right(@ids, len(@ids) - len(@s_id) - 1)
set @index = charindex(',', @ids)
end
return 1
END
GO
---------------
DECLARE @return_value intEXEC @return_value = [dbo].[MyTest]
@ids = N'1,2,3',
@commend = 4SELECT 'Return Value' = @return_value
偶想加一个@tblName来代替Commend表谢谢