Stored Procedures - What is the difference between "IS" and "AS" while creating procedure. Ex:- create procedure IS or

GeekInterview.com > Interview Questions > Database > Stored Procedures

Go To First | Previous Question | Next Question

Stored Procedures | Question 3 of 12

What is the difference between "IS" and "AS" while creating procedure. Ex:- create procedure IS or AS?

Total Answers and Comments: 5

Last Update: May 26, 2008 Asked by: Shekhar

Sponsored Links

Best Rated Answer

—

Submitted by: krishnaindia2007

Both are same.

Above answer was rated as good by the following members:
h.karamshil

April 18, 2006 03:10:29

prafull.vn

Member Since: March 2006 Contribution: 10

RE: what is the difference between "IS" and "AS" while...

both are equivalent .. Just replacement of DECLARE keyword in declarative section.

Is this answer useful? Yes | No

September 17, 2007 14:39:35

gopikumar

Member Since: September 2007 Contribution: 1

RE: What is the difference between "IS" and "AS" while...

There is no difference between "IS" and "AS" in Procedures........
We can use any of them while creating a procedure.

Is this answer useful? Yes | No

March 10, 2008 03:19:06

sampra

Member Since: February 2008 Contribution: 278

RE: What is the difference between "IS" and "AS" while creating procedure. Ex:- create procedure IS or AS?

both are same

Is this answer useful? Yes | No

May 23, 2008 07:12:10

praveengowda

Member Since: August 2007 Contribution: 3

RE: What is the difference between "IS" and "AS" while creating procedure. Ex:- create procedure IS or AS?

There is no difference as such
We use AS when Stored Procedure is defined in a package if SP is outside pkg we use IS. Here is the example

Ex: AS
Pakcage Header
create package schema.testpkg as

....
procedure sp_test(....);

end testpkg;

create package body schema.testpkg
is

procedure sp_test(..)
AS
....
end sp_test;

end testpkg;

Ex: IS

create schema.test_sp(....)
IS
..
BEGIN
..
END test_sp;

Is this answer useful? Yes | No

1 0

Overall Rating: +1

May 26, 2008 00:21:04

krishnaindia2007

Member Since: September 2007 Contribution: 854

RE: What is the difference between "IS" and "AS" while creating procedure. Ex:- create procedure IS or AS?

Both are same.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank