Thread: sqlserver

what is the query for seeing only stored procedures in 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;

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

select * from sysobjects where type='p'