Monday, November 16, 2009

Insert Procedure !!

/*
Procedure Name :customerInsert
Description : This Procedure is Inserting the Customer details
Created By: Chandrashekhar Dhingra
Creation Date :24/03/2008
*/

CREATE PROCEDURE customerInsert
(
@custName varchar(100),
@custAdd varchar(500),
@custCity varchar(100),
@custState varchar(100),
@custPin varchar(20),
@custCountry varchar(100),
@custEcc varchar(50),
@custTin varchar(50),
@custID varchar(50),
@regDate datetime,
@active varchar(3),
@delete varchar(3)
)
AS
insert into tblCustomerMaster
(

cust_name,
cust_address,
cust_city,
cust_state,
cust_pin,
cust_country,
cust_eccNo,
cust_tinNo,
custom_id,
cust_regDate,
cust_active,
cust_delete
)
values
(
@custName,
@custAdd,
@custCity,
@custState,
@custPin,
@custCountry,
@custEcc,
@custTin,
@custID,
getdate(),
'Yes',
'No'
)
GO

No comments: