使用存储过程新增数据，并执行存储过程

--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=''