setty
Joined: 01 Apr 2009 Posts: 117 Location: GOLLAPROLU
|
Posted: Thu Jul 02, 2009 5:24 am Post subject: |
|
|
Hi rahul,
Here is the sample example for inserting records into a table using stored procedure:
CREATE PROCEDURE [dbo].[sp_Receipt_Insert]
(
@ACCNo varchar(50),
@PartyName varchar(50),
@TRNo varchar(50),
@Amount decimal(18, 2),
@PhoneNo varchar(15),
@Date datetime,
@Time datetime,
)
AS
insert into Receipt(ACCNo,PartyName,
TRNo,Amount,PhoneNo,[Date],[Time]) values
(@ACCNo,@PartyName,@TRNo,
@Amount,@PhoneNo,@Date,@Time)
RETURN _________________ Thanks & Regards
(D.B.G.Setty) |
|