List the Stored Procedures in a SQL Server database
时间：2020-10-23 13:30:29|栏目：JavaScript代码|点击： 次
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
上一篇：移动端手指操控左右滑动的菜单
栏 目：JavaScript代码
下一篇：关于BootStrap modal 在IOS9中不能弹出的解决方法(IOS 9 bootstrap modal ios 9 noticework)
本文标题：List the Stored Procedures in a SQL Server database
本文地址：http://www.codeinn.net/misctech/15061.html
