search

Home  >  Article  >  Web Front-end  >  List the Stored Procedures in a SQL Server database_Image special effects

List the Stored Procedures in a SQL Server database_Image special effects

WBOY
WBOYOriginal
2016-05-16 19:12:061296browse

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

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Comparison of three modes of script installation that need to be imported (loaded)_javascript skillsNext article：Comparison of three modes of script installation that need to be imported (loaded)_javascript skills

Related articles

See more