摘要: 参考: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 nzperfect 阅读(158) | 评论 (2) 编辑 |
