Follow by Email

Saturday, 8 September 2012

Insert Into Table Stored Procedure

CREATE PROCEDURE insert_pro
    -- Add the parameters for the stored procedure here
 @order_no int,
 @customer varchar(50),
 @amount numeric(10,2),
 @order_date datetime
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    INSERT INTO orders (order_no,customer,amount,order_date) VALUES(@order_no,@customer,@amount,@order_date)
END



0 comments:

Post a Comment


                                                            

 
Design by Abhinav Ranjan Sinha