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