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
如对本文有疑问, 点击进行留言回复!!
asp.net中ajax和一般处理程序(handler.ashx)的交互
egg.js创建项目,目录介绍,简单使用,sequelize mysql使用
网友评论