USE Northwind
GO
------------------------------------------------
Create PROCEDURE sp_EmployeeID
@list nvarchar(4000),@LastName nvarchar(20)
AS
declare @sql nvarchar(4000)
set @sql='UPDATE Employees SET LastName='''+@LastName+''' WHERE EmployeeID in ('+@list+')'
print @sql
exec(@sql)
GO
---------------------------
EXEC sp_EmployeeID '1,3,4,6','newname'
将employeeid为1,3,4,6 的LastName更新为newname