xml形式参数 添加存储过程的创建

create procedure [dbo].[FirstPayedAdd]
@Input varchar(max)
as
begin
 DECLARE @x XML, @ID VARCHAR(20);
 SET @x = @Input;
 SELECT @ID = dbo.NextID_FirstPayed();  
 insert into FirstPayed(
  ID,
  Orders,    
  IsPayed
  )
 select
  @ID AS ID,
  x.item.value('(Order/@ID)[1]','varchar(50)')Orders,
  x.item.value('IsPayed[1]','bit')IsPayed  
 from @x.nodes('//FirstPayed') as x(item);
end