IF EXISTS(SELECT * FROM sysobjects WHERE name = 'prApp_InvItems_Insert')
DROP PROC prApp_InvItems_Insert
GO
----------------------------------------------------------------------------
-- Insert a single record into InvItems
----------------------------------------------------------------------------
CREATE PROC prApp_InvItems_Insert
@InvNO char(10),
@PONO char(20) = NULL, --未指定时的默认值.
@Style char(25) = NULL,
@FactPO char(15) = NULL,
@Item char(15) = NULL,
@Qty int = NULL,
@type char(10) = NULL,
@Price money = NULL,
@MoneyAmount money = NULL
AS
INSERT InvItems(InvNO, PONO, Style, FactPO, Item, Qty, type, Price, MoneyAmount)
VALUES (@InvNO, COALESCE(@PONO, '-'), COALESCE(@Style, '-'), COALESCE(@FactPO, '-'), COALESCE(@Item, '-'), COALESCE(@Qty, 0), COALESCE(@type, '-'), COALESCE(@Price, 0), COALESCE(@MoneyAmount, 0)) --测试空值.
GO