---- 以下語(yǔ)句將列出數(shù)據(jù)庫(kù)中(PUBS數(shù)據(jù)庫(kù))存貯過(guò)程

pubDatabase =oSQLServer.Databases(“pubs”)
’oSQLServer是前面創(chuàng)建的SQL Server服務(wù)器對(duì)象
For Each DBSP In pubDatabase.StoredProcedures
Response.Write DBSP.Text
Next

---- 程序運(yùn)行的結(jié)果（取數(shù)據(jù)表名）：

---- 取存貯過(guò)程的結(jié)果：

---- 一個(gè)完整的小例子源碼附后（其它功能讀者可加入）。

< %@ LANGUAGE = VBScript % >

< HTML >
< HEAD >
< META NAME="GENERATOR" Content=
"Microsoft Developer Studio" >
< META HTTP-EQUIV="Content-Type"
content="text/html; charset=gb2312" >

< TITLE >< /TITLE >
< /HEAD >

< %
On Error Resume Next
Dim oSQLServer
Set oSQLServer = CreateObject ("SQLOLE.SQLServer")


strServer = "dep"
strLogin = "sa"
strPwd = ""


oSQLServer.Connect strServer,strLogin,strPwd


% >


< BODY BGCOLOR=#ffffff >
數(shù)據(jù)庫(kù)列表
< SELECT NAME="Database" >
< %
For Each SQLDB In oSQLServer.Databases
If Not SQLDB.SystemObject Then
Response.Write "< OPTION VALUE=
""" & SQLDB.Name & """ >" & SQLDB.Name

& " "
End If
Next
Set oSQLServer = Nothing
% >
< /SELECT >
< /BODY >
< /HTML >