多个记录更新（存储过程）

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