{"id":551,"date":"2010-10-01T03:44:53","date_gmt":"2010-10-01T03:44:53","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=551"},"modified":"2012-04-22T13:40:06","modified_gmt":"2012-04-22T13:40:06","slug":"sqlserver%e5%b8%b8%e7%94%a8%e7%9a%84%e5%ad%98%e5%82%a8%e8%bf%87%e7%a8%8b","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2010\/10\/01\/sqlserver%e5%b8%b8%e7%94%a8%e7%9a%84%e5%ad%98%e5%82%a8%e8%bf%87%e7%a8%8b\/","title":{"rendered":"SqlServer\u5e38\u7528\u7684\u5b58\u50a8\u8fc7\u7a0b"},"content":{"rendered":"<p>?<br \/>\n1\uff0c\u67e5\u770b\u6570\u636e\u5e93\u7684\u7248\u672c<br \/>\nselect @@version<\/p>\n<p>2\uff0c\u67e5\u770b\u6570\u636e\u5e93\u6240\u5728\u673a\u5668\u64cd\u4f5c\u7cfb\u7edf\u53c2\u6570<br \/>\nexec master..xp_msver<br \/>\n\u67e5\u770b\u6570\u636e\u5e93\u542f\u52a8\u7684\u53c2\u6570<br \/>\nsp_configure<br \/>\n\u67e5\u770b\u6570\u636e\u5e93\u542f\u52a8\u65f6\u95f4<br \/>\nselect convert(varchar(30),login_time,120) from master..sysprocesses where spid=1<br \/>\n\u67e5\u770b\u6240\u6709\u6570\u636e\u5e93\u540d\u79f0\u53ca\u5927\u5c0f<br \/>\nsp_helpdb<br \/>\n\u67e5\u770b\u6240\u6709\u6570\u636e\u5e93\u7528\u6237\u767b\u5f55\u4fe1\u606f<br \/>\nsp_helplogins<br \/>\n3\uff0c.\u67e5\u770b\u67d0\u6570\u636e\u5e93\u4e0b\u67d0\u4e2a\u6570\u636e\u5bf9\u8c61\u7684\u5927\u5c0f<br \/>\nsp_spaceused @objname<\/p>\n<p>4\uff0c\u67e5\u770b\u6570\u636e\u5e93\u91cc\u6240\u6709\u7684\u5b58\u50a8\u8fc7\u7a0b\u548c\u51fd\u6570<br \/>\nuse @database_name<br \/>\nsp_stored_procedures<\/p>\n<p>sp_help \u67e5\u770b\u8868\u7ed3\u6784\uff0c \u5b58\u50a8\u8fc7\u7a0b\u5b9e\u53c2<\/p>\n<p>5\uff0c\u67e5\u770b\u5b58\u50a8\u8fc7\u7a0b\u548c\u51fd\u6570\u7684\u6e90\u4ee3\u7801<br \/>\nsp_helptext <a href=\"mailto:'@procedure_name'\">&#8216;@procedure_name&#8217;<\/a><\/p>\n<p>\u6216\u8005OBJECT_DEFINITION(object_id(&#8216;sys.sysobjects&#8217;))<br \/>\n\u6216\u8005select * from sys.system_sql_modules<br \/>\nwhere object_id = object_id(&#8216;sys.sysobjects&#8217;)<\/p>\n<p>6\uff0c\u67e5\u770b\u6570\u636e\u5e93\u91cc\u7528\u6237\u548c\u8fdb\u7a0b\u7684\u4fe1\u606f<br \/>\nsp_who<br \/>\n\u67e5\u770bSQL Server\u6570\u636e\u5e93\u91cc\u7684\u6d3b\u52a8\u7528\u6237\u548c\u8fdb\u7a0b\u7684\u4fe1\u606f<br \/>\nsp_who &#8216;active&#8217;<br \/>\n\u770b\u8fdb\u7a0b\u6b63\u5728\u6267\u884c\u7684SQL\u8bed\u53e5\uff1a<br \/>\ndbcc inputbuffer (51) 51\u4e3a\u8fdb\u7a0b\u53f7<\/p>\n<p>7\uff0c\u67e5\u770bSQL Server\u6570\u636e\u5e93\u91cc\u7684\u9501\u7684\u60c5\u51b5<br \/>\nsp_lock<br \/>\n\u8fdb\u7a0b\u53f71&#8211;50\u662fSQL Server\u7cfb\u7edf\u5185\u90e8\u7528\u7684,\u8fdb\u7a0b\u53f7\u5927\u4e8e50\u7684\u624d\u662f\u7528\u6237\u7684\u8fde\u63a5\u8fdb\u7a0b\u3002spid\u662f\u8fdb\u7a0b\u7f16\u53f7,dbid\u662f\u6570\u636e\u5e93\u7f16\u53f7,objid\u662f\u6570\u636e\u5bf9\u8c61\u7f16\u53f7<\/p>\n","protected":false},"excerpt":{"rendered":"<p>? 1\uff0c\u67e5\u770b\u6570\u636e\u5e93\u7684\u7248\u672c select @@version 2\uff0c\u67e5\u770b\u6570\u636e\u5e93\u6240\u5728\u673a\u5668\u64cd\u4f5c\u7cfb\u7edf\u53c2\u6570 exec ma [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-551","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/551","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=551"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/551\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=551"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=551"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}