Stored procedure receives multiple parameter problems Master invited

cihcihxxc

SET @sql = 'UPDATE Images SET [Name] = `` Test' 'WHERE ID IN (' + @idStrings + ')'

Where did @idStrings come from? ? ? ? ? ? Wrong?

=================
It is really wrong, it should be @idString

mgs_pexp

pupupu01written OK
The complete error-free stored procedure is as follows:
CREATE PROCEDURE Test
(
@idStringNVARCHAR (1000)-if its value is 1,2,3,4,6,7,8,
)
AS
update usertable set username = 'test' where charindex (',' + rtrim (id) + ',', ',' + @ idString + ',')> 0
GO

tyrealkfir

If you don't want the page to loop, you have to loop through the stored procedure
First combine your id into a string and assign it to the stored procedure as a parameter, then use while while in the stored procedure
+ charindex for loop

xia_4658

Splitting a string in a stored procedure feels annoying, and it is better to assemble the string in a program.

sunray

...............
The parameters of the stored procedure are unchanged. The parameters have changed, and the copy must also change. Otherwise it will be the same