Loading
Write a simple stored procedure code with Parameter?
4 Answers
CREATE PROC PROC_Name
(
@EMPID BIGINT,
@EMPNAME VARCHAR(50)
)
AS
BEGIN
INSERT INTO EMPLOYEE(EMPID,EMPNAME)
VALUES (@EMPID,@EMPNAME)
END
Ashish SrivastavaPosted Dec 26, 2017, 6:48 AM
create or replace procedure projprssample
(rs out sys_refcursor)
is
begin
open rs for
select * from users where rownu<=10;
end;
Shalu ShaliniPosted Apr 1, 2017, 2:28 AM
create or replace procedure projprssample
(rs out sys_refcursor)
is
begin
open rs for
select * from users where rownu<=10;
end;
Shalu ShaliniPosted Apr 1, 2017, 2:27 AM
Create Procedure GetCustomerInfoById
(
@CustomerId INT
)
As
BEGIN
SELECT * FROM Customer where CustomerId=@CustomerId
END
Rahul ChavanPosted Apr 7, 2016, 10:18 PM