sql server£¬²ð·Ö×Ö·û´®£¬²¢´æÈë±íÖÐ

ALTER PROCEDURE [dbo].[putaway_insert]  
   -- ²åÈë putawayÐÅÏ¢·µ»Øid
   (
   @receive_number       varchar(255) = null
   ,@tray_code       varchar(255) = null
   ,@storage_location       varchar(255) = null
   ,@materiel_code       varchar(MAX) = null
   ,@materiel_quantity       int = null
   ,@batch       varchar(255) = null
   ,@sort       int = null
   ,@remark1       varchar(255) = null
   ,@remark2       varchar(255) = null
   ,@remark3       varchar(255) = null
   ,@remark4       varchar(255) = null
   ,@remark5       varchar(255) = null

   )
   as
    declare @n int 
   SET @n = CHARINDEX(',', @materiel_code)
   
   WHILE @n > 0 
    BEGIN 
     INSERT INTO putaway
     (
       receive_number
       ,tray_code
       ,storage_location
       ,materiel_code
       ,materiel_quantity
       ,batch
       ,sort
       ,remark1
       ,remark2
       ,remark3
       ,remark4
       ,remark5
     )
     VALUES  (
       @receive_number
      ,@tray_code
      ,@storage_location
      ,Left(@materiel_code,@n-1)
      ,@materiel_quantity
      ,@batch
      ,@sort
      ,CONVERT(varchar(100), GETDATE(), 20)
      ,@remark2
      ,@remark3
      ,@remark4
      ,@remark5
     )
     Set @materiel_code = SubString(@materiel_code,@n+1,Len(@materiel_code)-@n)
     Set @n = CharIndex(',',@materiel_code)
    END 
    
    select @@IDENTITY

1¡¢¸ù¾Ý¶ººÅ¡°，¡±²ð·Ö materiel_code×Ö¶Î，²¢°Ñ²ð·ÖºóµÄ×Ö·û´®，´æÈë±íÖÐ

2¡¢CONVERT(varchar(100), GETDATE(), 20) ²éѯµ±Ç°Ê±¼ä，¸ñʽ yyyy-MM-dd HH:mm:ss