xml 形式的参数 删除存储过程的创建

create  procedure [dbo].[FirstPayedListDeleted]
@Input varchar(max)
as
begin

 SET NOCOUNT ON;   
 DECLARE @x XML, @ID VARCHAR(20);
 SET @x = @Input; 
with ae as
(
 SELECT
     x.item.value('@ID[1]', 'VARCHAR(20)') AS ID  
 FROM @x.nodes('//ArrayOfFirstPayed//FirstPayed') AS x(item)
)
delete FirstPayed
from FirstPayed as a ,ae as x where a.ID=x.ID
end