List the Stored Procedures in a SQL Server database
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
相關(guān)文章
感應(yīng)鼠標(biāo)的圖片遮罩動(dòng)畫(huà)效果
感應(yīng)鼠標(biāo)的圖片遮罩動(dòng)畫(huà)效果,鼠標(biāo)放上后會(huì)動(dòng)畫(huà)顯示文字提示,有意思哦,有興趣的朋友運(yùn)行一下看效果。2010-10-10JavaScript圖片放大鏡效果代碼[代碼比較簡(jiǎn)單]
實(shí)用漂亮的放大鏡效果,基于JavaScript代碼實(shí)現(xiàn),貌似代碼不太多,但效果確實(shí)不錯(cuò),因調(diào)用的圖片比較大,所以運(yùn)行效果后請(qǐng)稍等一會(huì),等待圖片加載。2011-02-02