摘要:参考:http://www.mssqltips.com/tip.asp?tip=2444 取硬盘大小及可用空间declare@svrNamevarchar(255)declare@sqlvarchar(400)--bydefaultitwilltakethecurrentservername,wecanthesettheservernameaswellset@svrName=casecharindex('\',@@servername)when0then@@servernameelseleft(@@servername,charindex('\',@@serve
阅读全文
posted @ 2011-07-28 16:09