4
Reply

Write a simple stored procedure code with Parameter?

Rahul Chavan

Rahul Chavan

Apr 07, 2016
469
0

    CREATE PROC PROC_Name ( @EMPID BIGINT, @EMPNAME VARCHAR(50) ) AS BEGIN INSERT INTO EMPLOYEE(EMPID,EMPNAME) VALUES (@EMPID,@EMPNAME) END

    Ashish Srivastava
    December 26, 2017
    0

    create or replace procedure projprssample (rs out sys_refcursor) is begin open rs for select * from users where rownu<=10; end;

    Shalu Shalini
    April 01, 2017
    0

    create or replace procedure projprssample (rs out sys_refcursor) is begin open rs for select * from users where rownu<=10; end;

    Shalu Shalini
    April 01, 2017
    0

    Create Procedure GetCustomerInfoById ( @CustomerId INT ) As BEGIN SELECT * FROM Customer where CustomerId=@CustomerId END

    Rahul Chavan
    April 07, 2016
    0