Home > SQL > Mendapatkan daftar stored procedure dan function di MSSQL 2000

Mendapatkan daftar stored procedure dan function di MSSQL 2000


Berikut ini ada cara sederhana untuk mendapatkan semua fungsi dan stored procedure yang terdapat
di Microsoft SQL Server 2000. Cara berikut ini juga akan menyertakan script stored procedure juga.

select c.id,type,c.text,o.name from dbo.syscomments c
join dbo.sysobjects o on o.id=c.id
where (type='P' or type='FN')
order by c.id,type
Categories: SQL
  1. May 22, 2013 at 12:23 pm

    This is my first time pay a quick visit at here and i am actually impressed to read all at
    one place.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: