List the Stored Procedures in a SQL Server database. Supported Platforms SQL Server 2000 Yes Script Code strDBServerName = "." strDBName = "Northwind" Set objSQLServer = CreateObject("SQLDMO.SQLServer") objSQLServer.LoginSecure = True objSQLServer.Connect strDBServerName Set objDB = objSQLServer.Databases(strDBName) Set colStoredProcedures = objDB.StoredProcedures For Each objStoredProcedure In colStoredProcedures WScript.Echo "SP Name: " & objStoredProcedure.Name Next

　　推荐阅读

　　Add a Table to a Word Document

Demonstration script that retrieves service information from a computer and then displays that information in tabular format in Microsoft Word.复制代码 代码如下:Set objWord = CreateObject("Word.Appl>>>详细阅读

本文标题：List the Stored Procedures in a SQL Server database

地址：http://www.17bianji.com/kaifa2/JS/30360.html

 1/2    1