--2014-10-28
--增加入账信息
ALTER PROC [dbo].[Add_In_Info]
(
@person_in nvarchar(20),
@project_name_in nvarchar(20),
@project_script_in nvarchar(100),
@money_in decimal(18,2),
@date_in datetime,
@state_in nvarchar(10)
)
AS
BEGIN
INSERT INTO Account_In(person_in,project_name_in,project_script_in,money_in,date_in,state_in)
SELECT ISNULL(@person_in,'') as person_in,
ISNULL(@project_name_in,'') as project_name_in,
ISNULL(@project_script_in,'') as project_script_in,
ISNULL(@money_in,0) as money_in,
@date_in as date_in,
@state_in as state_in
END
执行存储过程:exec [Add_In_Info] @person='',@project_name_in='',@project_script_in='',@money_in='',@date_in='',@state_in=''