-
Junior Member
sqlserver
what is the query for seeing only stored procedures in sqlserver
-
Junior Member
Re: sqlserver
CREATE OR REPLACE PROCEDURE [SCHEME.] procedurename
(argument {IN, OUT, IN OUT} data type,....) {IS, AS}
variable declarations:
constant declarations;
BEGIN
PL/SQL subprogram body;
EXCEPTION
exception PL/SQL block;
END;
-
Contributing Member
Re: sqlserver
Hi Gopi,
Its' simple just run the following query
Select * from sysobjects where xtype='P'
---V V---
Vikas Vaidya
Please mark this post as thank if u found it useful
-
Junior Member
Re: sqlserver
select * from sysobjects where type='p'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules