知方可补不足~sqlserver中使用sp
回到目录 在SQLSERVER中每个会话,即每个查询分析器窗口都会产生一个SQL进程,对于那些持续时间短的进程,它们转瞬即失,而对于持续时间比较长的,我们需要希望查看它的运行状态,就可以借助SQL提供的sp_who命令,下面是对它的具体介绍,主要选自MSDN. sp_wh
回到目录
在SQLSERVER中每个会话,即每个查询分析器窗口都会产生一个SQL进程,对于那些持续时间短的进程,它们转瞬即失,而对于持续时间比较长的,我们需要希望查看它的运行状态,就可以借助SQL提供的sp_who命令,下面是对它的具体介绍,主要选自MSDN.
<strong>sp_who</strong> [ [ <strong>@loginame = </strong>] <strong>'</strong><span>login</span><strong>' | </strong><span>session ID</span><strong> | 'ACTIVE' </strong>]<br>你可以在sp_who后面加你的SPID号(sessionID),登陆名,线程状态等<br><br><img src="/static/imghw/default1.png" data-src="/inc/test.jsp?url=http%3A%2F%2Fwww.cnblogs.com%2Flori%2Fp%2Fdata%3Aimage%2Fpng%3Bbase64%2CiVBORw0KGgoAAAANSUhEUgAAAkoAAACnCAIAAABhBOS7AAAgAElEQVR4nO1du24kObLNr1msI0F2WmMssLYAyV5nUL4GEIT1%2Bg9UAwho7CdcoLHGFZDfMLhWG%2B3Vx9Q18sEg48FHMjMjVDxIDHqyyGAwGMHDYJXI7tfPv759%2B%2FZbQ0NDQ0PDF0K30Nt1M2wqfM9W9unIPrDVF1vaKkR1A7YRqQiLxjShs0dvv37%2BVf2B3LmF%2FN1a2acj%2Bzy2%2BmJLW4VPdQO2Ean4WDSmFZ0bvSlqYrfHVl9saavwafSm%2BbFoTCs6N3pT1MRuj62%2B2NJW4dPoTfNj0ZhWdLZDb58vD%2Fcvww7mZhqyMqLlgyJauGlr90k14PgmwbDxWEgW1Z4d5i7VOm%2F0fL483L9opTcu9qqbO7mhpCYEJTWF%2BlrC2Lcv1ehN0xDs%2BTR60%2Fw0eqvQO8aZtdJb5shpyd5uhN6Maqu1g1oM2OhNz%2BiUPTdLb0zhw%2BhteL3ruq7ruofXH78%2BXx7uH5%2FvxxeP32FPPl8euhkF9Oaq3719ji%2Ffn2d5zx8ZDSV05P3t3lX%2FrSI654%2FfriP4CDN%2Fassb2jROY7Z4rH76EZQRc%2BXx7uX96elj7%2B9Svs9V9wZBf7TH0khiZb26B1rDk9OntpruThDUgFnfPP9%2BfMWKD8hGjidixfPjqL%2FfPMIk2SO3rU43c8UuQc4ioGM89Ui5tdQ5WYafwoent%2FXtx9sgXoz9P7rO6Pt%2Ft55vp4zKe3H2%2F3wLiBwJ%2Fvz93d20dqQ6kdwXWDWYMYV1%2FIkd7pmWIaC2gc2JfPl4fOf0%2F2ehxZ%2BI%2BplWBo8rUNW8eaM6Ozl%2BZKnqgBvaBzPslSCB9ufhCRTdyS5ctHh5ypWLMkTZK7eNQ4QOTEO79ZfCOcBnGthNk1lOCZ4ih6%2BxGuPmBXl56QDJ9nboiFzJBdEhoq6gi1WqHHFQg50DtJU3BvIusvpteAGr2h4Rfj8b01Vh9mdPbSXMmTZEAYdGPPnt4rj0gwQ92A5euMDjZXYJa0SXI%2FneWJV5hVwvHlZ9fgYWQe%2FN3b96euI52%2BGr35yZCwYCykN64jYPEbz958Icd65yp6S%2Bi1c%2BXUnq6gN2Z09tJcyZNnwKmDMHuoNyI3Zvk6oxO8sUFv%2FMQr0Rs9vgRNBI8uevv009gP1zFuc3J4vSvanITfygRBS29Ocg2ldsTR2zxUYTJOfYST%2BsO8M2dzkpiqmF6H%2F8BDUxpLgubc6OyluZInuvijNiel3kXDbQoirombsXz56LAzlWQWeZLcw6Om1vFIgUXMtIOKxh3XYmdX9DCm0PPTkruHZXciGMLp%2FV129jZ5RrCVEftpCdNQUkcm4Y%2Ffwfu5U9RHc1tKf1oCZyK8fUQtG8Nes1MVOTRlsSRpTo%2FOXporeeJb90w2MLzekX2M%2F7RkdGyuiZuxfPnoeJ1FM1XRJLmHR7nW0Uh9PHKTHlA7rMXNrqFKjCl0%2FGHA6py6nVqyU18%2BHoWvZNRp255tDNhGpOJj0ZirdN5rB%2FWXllNLGr3t%2B2T2xa0iD1k1fyXLH%2FI0etP8WDTm0fQGZ6QR9E61Dnqz0IpFL%2FwafbGlrcKn0Zvmx6Ixrejs0du3bbAYYiP5u7WyT0f2ga2%2B2NJWIaobsI1IRVg0pgmdHb1tiuv1unUT%2B7SyT0f2ga2%2B2NJWIaobsI1IRVg0pn6dHb0dnki2pz3taU972lPr8ejtug02FQ6xQyv7dGQf2OqLLW0VoroB24hUhEVj6tc5pLfq%2FLk1d0I0esuCrb7Y0lYhGr1phkVj6te50Zu6JnaDrb7Y0lYhGr1phkVj6te50Zu6JnaDrb7Y0lYhGr1phkVj6tc5hd7A4WBb0Ntwmv4y7zQEL5Y3iRBaKZaZ3sSuuJz7%2FnxZV0ZLX9KQNbjMcA%2BncPjxm3KByJHzauG2pheXcw%2F%2BftXV9N9HXbt6dHACnbREzRKR6PM1moViqugeBT86gYvO%2F0v2VO7%2BcOo6Z0F6mHKcaof5diVkepsv4dyQ3obTbIHh1PXny%2BXcw7HKMg7biguMlBApamJnNHqbQTgMMdxL1C4Ohd%2BsEzi67%2FSveQKK1SLakuSgGnB8i4e7NDpi%2FkMvHfLbyanF2SpH1OXcByyQNAutm1pK6G1pDvoX3%2F3h1J1OJ6SjLz%2BnFzvMtytxdPbmgplArm2kVsAstGY9oYUSGr1RmHrMDndq9rZCoKuUWQsP1%2FyCo7GwQqQv1aOjnN7KUODzXBVJVOmMfCC90S8x252G64D4bQN6qzffrsTB9CYmaNWyN3KhUwapI13Xjck%2F1R4qcDoFy3%2B3LeAmtbOwTxXkA8syAZdZ0xd%2FE%2BNAT02gt8lh%2BOHOpbcCgVTKl1ILe%2FvygqOxStlbcXRk0RsRINkePr2RHJKxlV9llkhKExhRCk9PJlV4jHfW2TbI3vy6I7sR3atPbxXn25U4nt7wPL98JM%2FOGMfRG9wQPw1Ee6jA3DdiMlyCH8b8NCvMb6asF9UiyqzrC%2FzkUFeN0tti1Fr0ViBwnNbGV1n0Fng7lIPMjlZMaWuPQ%2BmNChDZw1P8GavL2Sp4QfZT%2BCglPF0RsnDEriX05oY%2BmAQItSd2IyyC6C3ZqRq9JWRvwTwfvs%2FAcfQ2OQWx4QyilC0AFn%2FOXwckBItNqbWyL1ff47XSG3SYMnqbVvEwly4ReC3I%2BRhvp9JAWN17jxcjIQ6lN8r%2FSX%2BOvrkSDunGTrAVrBIGIPMRtFF6eMqFs42ZsjkJ9KSzN18nLsPjxGbq3OhtBtgK9tyjyCRCK%2Ft89zacuo7O3mIF5FRJordYrZV9gWtmrdlb6DCrv3tbIXCqDjN2uZbg7W5pBAvAOGGUJFE9OrI2J5dXzv8L6U10SNpWqIorhqVRXp4VnnJhBrwx%2Fcrc6EvdB7kbUah997btLyfd%2BmLeJi80CNsKuW9QsQk3RY3y%2FeH1dicu574%2FD%2BSP8%2FxXTArojOW%2FATlDUKZ2X3LMVRFSLLGzSZQBqOgrEohHIkkN1JYoB30uLMMRqkdHBr1h%2F6epC%2FcO%2B7PokLStqHh09BZK8wNnHKGE8PTMyBfON6Y3rnC%2BjNCbZzqS9bD4OvRWb75dicPpDXy3O3tix6XRMcgukrCZXN7EkvyH%2BxN93y8xsxS4nPu%2B78MeLjrOFYRtmVlsWIsuU6kvueNRFZy2pMMww51Eb8UC0UjEa8ltgdnSgV2Fx%2FYnq0dHVvaG%2FD914xH7s%2BSQjK1QlbHH87oSSYMv4UrEFaLTyqU4X7jEmEAdeW%2BG7j5aBXieIn%2F3JkX8DvPtSrRTS45o4uA1zYR9BqUWbGmrENUNuO2IHLurtTssurd%2BnRu9HdFEo7d82NJWISzQG8xmFUTIjrDo3vp1bvSmrondYKsvtrRVCAv0druwaEz9Oof0tsWN4I3edMJWX2xpqxCN3jTDojH16%2BzR24pbvyNo9KYQtvpiS1uFaPSmGRaNqV9nj96sP13X7fDf9rSnPe1pj%2F4n3JzcAntmb%2Fzv%2F%2B36dN13Q4d2Qf7DEot2NJWIaobsI1IRVg0pn6dv9RPS7qu25re9I9oOmz1xZa2CtHoTTMsGlO%2Fzl%2BK3lr2lgX93glhS1uFaPSmGRaNqV%2FnL0VvLXvLgq2%2B2NJWIRq9aYZFY%2BrXOUJv35%2FmP7J8et%2BK3vxDua4rDnThsrc%2Ff7%2FzD5p5%2FLfy7C16VmwN6PdOCEFb7DBrDuUqFogcOa8WbgucW%2BhAnHOVFi5ZBkwBJzA4aawgkGmkhABnq%2Fym6uoeBT86KRfixFxlqUqdAehVyHGq6h5VHRK9Da93M6v9eLvvnj%2B2oDd3pqw7fBifUpvYmZTs7T9%2FO2ff2rP3hq9IXDapp1lvEQtPoYwdLFCge5gP3xlCVuLaEuSg2rwB%2BWmG3CPI5XZFnOQSG%2BkrXJEUUcqV1KPRwm9kSd28t0fTt3phC7rvvkjlSeqe3j9UZ%2FexEPoc23DZW%2Fw%2Bfc%2F7%2F71H%2FXfvTV6Q0jR1p1tm3p%2FTeRkw3yBrlLhNTr4BUdjtW4M2PFCnFXIpje%2BiiSqNNIOpDf6JWa703AdEL%2Fd%2BoU4G2ZvYoK2Qfb2nz%2F%2B9vc%2Fqz%2B3dvl7C4dp67JOMPtJvzG3yiYy%2Fi3mBNHqq%2Bluy9Hb5fce0Rj0VcgkEr5Umphb19ecDRWKXvj9Ywgi964GwPOwk4sc4dAGCxcZ4AOfpVZIilNYESoRKi8J5MqPIYz62wbZG9%2B3ZHdiO7Vp7dij6qOJHobXu%2B6%2B5dhg%2B%2Fe8DQOP8qdwKPZ25%2B%2F3%2F3jWzm3sdnboise2At1aX3wJrSIV8afYkGF1Y7zxehNGIS5SB69FQgcp7Vl4NLpLfB2KAcNNMjqOojIUvBQeoPfGIHrTMM%2B4q1X8CZyuxv5hkmJyX4KH%2BG4I%2BMa78i5whG7ltCbG3puTvB0wm5JyM9xqq9Ab2u4LSl7c%2Fb3vxjJt0oXyd7%2B%2FMeKH5XEsje0esLRwr25oiVqUMafETrs1kX4SvQGHaaM3qZVPFjsFgm8FuR8jLdTaSCs7r1HyR%2FCofQ2Oa43%2F9cKFjh2gq2k%2BGI%2BgjYK4m7gVZULZxszZXMS6Elnb75OXIbHic3U2Qy9reS2KL3BrWDPPYpMImdvf%2F5%2B97ff%2F7uG26TsbRW9gXWpXCs%2BieWZq5KkPSBoGzrM6u%2FeVgicqk%2BjmlBL8HacsYO3aOaIfcshxOBu370Np3knr5zeULDABmhbCfGFpVETMo47QVW5MAPemH5lbvSl7oPcjSh0s9%2B9fTx2K%2B7pTqI3f30xb5MXGkTM3v77r7%2Bv%2BlFJUvYWDGxGxKJawS%2FqXOyFP7UrxhehN%2Bww5DbRVDSB3ooEEgOTogZqS5SDPheW4QisAVk9I8igN8fhl3M%2FZzNEIODeuTezDBQsdF%2BuwFZCVBLS%2FAXHOEJoWKS4FgvnGzP8OxJmk5HvPst6WHwdeiv1qOqQ6M390VvXdV23yS8nr%2BGf%2BQR%2FjZFlGyl7%2B%2FbYrfh7gNTsDe4C9H36fou3d9D7m5DhYm2x0Fq%2F%2BRr0RjoM82c3SfRWLBAPTLSW3BaYLR3YVXhsvSNPoJSeEWRlb0snXIJE7mGRng8DCgcLbJOxFaoy9nhaPGBp8CVcibhC9CJ1Kc4XLjEmUEfe9aO7j1YBnqfI371Js0x1j6qOdmpJjezNJmz1xZa2ClHdgNuOyLG7WrvDonvr1%2FlL0ZuUvVV6unbm5EGwpa1CWKA3mM0euam1Pyy6t36dvxS9tewtC7b6YktbhbBAb7cLi8bUr3NIb982QMvedEK%2Fd0LY0lYhGr1phkVj6tfZo7ffNkPL3hTCVl9saasQjd40w6Ix9evs0dsXeLqu2%2BG%2F7WlPe9rTHuVPuDm5BfbcnPwCTewGW32xpa1CVDdgG5GKsGhM%2FTp%2FqZ%2BWNHrLgq2%2B2NJWIRq9aYZFY%2BrXudGbuiZ2g62%2B2NJWIRq9aYZFY%2BrXudGbuiZ2g62%2B2NJWIRq9aYZFY%2BrXOUJvy7lcZZe9JdHbENz4VH6gS8zc%2FgmBHlJb0jKiKWe5xcpo6UsaBG2xw6w5lKtYIHLkvFq4LdJZiXOu0pw4y4Ap4AQGJ40VBDKNRJ%2Bv0Sx1KNe24Ecn5UKcmKssVYPDNPEw5ThVdY%2BqjtiRytN1Ae%2FPpWcrJxyp7I5pIw8TTgffyjJolDzvOO3iJvZFo7cZaWcZYwdgXaJQoDvYD19ZwtYi2pLkoBr8QbnpBtzjSGW2xRxk%2Bzw%2FgYiiqCOVK6nHo4TeyBM7%2Be4Pp%2B50Qpd13%2ByRyuD58XZ%2F9%2Fa5Ab3hM78Bcm1TFm%2F4evYVTeyFRm8U3Nm2qffXRE42zBfoKhVeo4NfcDRW68aAHS%2FEWYUCn%2BeqSKJKZ%2BQD6Y1%2BidnuNBCz3c1eiLM8ny8P22RvYoJWMXsbQZk60ymljnRdBw9E9%2BWjAuiScnDXwDKpnYV9qvCEdeq089uit0vuPaKx6CsQSKV8KbWwty8vOBqrlL3xekaQFW7cjQE5Hu5fXsql3pSt%2FCqzRFKawIhSeHoyqcJjvLPOtkH25ted9qhw9%2BrTW7FHVUfabd2bffdGzvPLR7mnqhbQW87GpNAE3BCn7oLCBcJLykGdJfiD2%2B7hDDhlvagWUSa3L0oR1XYxai16KxA4Tmvjqyx6C7wdykEzBFoxMVN9gEPpjQoQ2cNT%2FBmry9kqeEH2U%2FgoJTzJHTlXOGLXEnpzQx9MAoTay0SH%2BidfiFOyH2CJ3ubNyUKGi2dvwTwfvs9APr1lp85ME5NTEBvOIErZAmDx5%2FxVuO3%2B6sVYpFZ2X5RC1hY6TBm9Tat4mEuXCLwW5HyMt1NpIKzuvUfJH8Kh9Eb5P%2BnP0TdOGMrAAqNDHYIqYQAyH0EbpYenXDjbmCmbk0BPOnvzdeIyPE5sps7m6O2v4fVuk%2BtMwVaw5x5FJsmltwLTy00Mp66js7dYATw7JQZ%2FtFZpX7RB0DZ0mNXfva0QOFWHGbtcS%2FB2tzSCBWCcMEqSEGJwt%2B%2FePP8vpDeQxEWzN66KK4alUWGTFZ5yYQa8Mf3K3OhL3Q82qUS%2FqUFvNr57G17vuqf3TbO3YH0xb5MXGiQz3koWFnQTbooaZfrD6%2B1OXM59fx7IH%2Bf5r5gU0BnLfwNyhqBMZl%2B0QooldjaJMgAVfUUC8UgkqYHaEuWgz4VlOAJrQFbPCDLCDfs%2FTV24d9ifUXDRfbkCW1Hx6OgtlOYHzjhCCeHpmZEvnG9Mb1zhfBmhN890JOth8XXordSjqiP1797KUrcEegPf7c6e2HFpdAx59Fa0rpB2WYHCbi%2Bg7%2FslZpYCl3Pf933Yw6XrcwVhW2YWG9aiy%2BT1RSc4bUmHGRL%2B4Ix5Uy4QjUS8ltwWmC0d2FV4bH9SnkApPSPICjfk%2F6kbj9ifPXtgeqNshaqMPZ7XlUgafAlXIq4QnVYuxfnCJcYE6sh7M3T30SrA8xT5uzdpBq7uUdXRTi05oomD1zQTvga9NSSiugG3HZFjd7V2h0X31q9zo7cjmmj0lg9b2iqEBXqD2ayCCNkRFt1bv86N3tQ1sRts9cWWtgphgd5uFxaNqV%2FnkN6%2BbYBGbzphqy%2B2tFWIRm%2BaYdGY%2BnX26O23zdDoTSFs9cWWtgrR6E0zLBpTv84evbWnPe1pT3va8zWecHNyC7TsTSds9cWWtgpR3YBtRCrCojH169x%2BWqKuid1gqy%2B2tFWIRm%2BaYdGY%2BnVu9Kauid1gqy%2B2tFWIRm%2BaYdGY%2BnVu9Kauid1gqy%2B2tFWIRm%2BaYdGY%2BnVOorfvT%2FsdynVdcaBLzNz0EUpZjWgZ0ZQ%2FDI%2BV0dKXNAjaYodZcyhXsUDsUVm1cFvg3EJ80hJxflLZjQG8nhFwAoOTxqqdzJTo8zWapQ7l2hb86KRciBNzlaUqdQagVyHHqap7VHUk0Nvny8OGZ066M2Xd4cP4lNo08K0sg4aPYcs7%2FEcLJTR6m5F2ljFyAOLNOoHYoxJqEW1JclAN%2FqDcdAPucaQy22IOsn2en0BEUdSRypXU41FCb%2BSJnXz3h1N3OqHLum%2F5SOVfP3%2B83d89PxXehhOnN3zmN0CubdLjLfCNepeA7IVGbxTc2bb0fRyp2dsKga5S4TU6%2BAVHY7VuDNjxQpxVKPB5rookqnRGPpDe6JeY7U7DdUD8dqsX4vz6%2Bdevj8fu6b34srcovYkJWsXsbQR5lYa%2FVittgjgQffmAvjEAXVIObhlYJrWzsE%2BF7iYgTju%2FLXq75N4jGou%2BAoFUypdSC3v78oKjsUrZG69nBFn0xt0YkOPh%2FuWlXOpN2cqvMkskpQmMKIWnJ5MqPMY762wbZG9%2B3WkVj7tXn96KPao6ZHp7f%2B4ev6%2B4yzSF3vA8v3yUe6pqVrzNbt2fTutDGm6Ik1e1oQLhJeWgzhL8wW33cAac6BnVIsrk9kUpotouRq1FbwUCx2ltfJVFb4G3QzlohkArJmaqD3AovVEBInt4ij9jdTlbBS%2FIfgofpYQnuSPnCkfsWkJvbuiDSYBQ%2BzLvUaH%2ByRfilOwH2KC3hdW2zd6CeT58n4Gy3ZIYC6Q0MTkFseEMopQtABZ%2Fzl%2BF2%2B6vXoxFamX3RSlkbaHDlNHbtNyBuXSJwGtBzsd4O5UGwuree5T8IRxKb5T%2Fk%2F4cfeOEoQwsMDrUIagSBiDzEbRRenjKhbONmbI5CfSkszdfJy7D48Rm6myC3n683XujVMZw0e%2FeaO8tMkkRvcXnhfQmhlPX0dlbrADWIjH4o7VK%2B6INgrahw6z%2B7m2FwKk6zNjlWoK3u6URLADjhFGShBCDu3335vl%2FIb2B5Wg0e%2BOquGJYGhU2WeEpF2bAG9OvzI2%2B1H2QuxGFbvm7Nz%2BNq09v%2Fvpi3iYvNEh6vDkPzGyObsJNUaN3oC%2F5ggID%2BeM8%2FxWTAjpjBVs3LmcIymT2RSukWGJnkygDUNFXJBCPRJIaqC1RDvpcWIYjsAZk9Ywgg96w%2F9PUhXuH%2FZn8Bh335QpsRcWjo7dQmh844wglhKdnRr5wvjHD71SYTUa%2B%2ByzrYfF16K3Uo6rjcHoD3%2B3OnthxaXQMWcvJAf2V0pomluQ%2F3J%2Fo%2B36JmaXA5dz3fR%2F2cNForiBsy8xiw1p0mby%2B6ASnLekwA%2F1nN0n0ViwQjUS8ltwWmC0d2FV4bB9CnkALgiEr3JD%2Fp248Yn%2F27IHpjbIVqjL2eF5XImnwJVyJuEJ0WrkU5wuXGBOoI%2B%2FN0N1HqwDPU%2BTv3qQZuLpHVUc7teSIJg5e00z4GvTWkIjqBtx2RI7d1dodFt1bv86N3o5ootFbPmxpqxAW6A1mswoiZEdYdG%2F9Ojd6U9fEbrDVF1vaKoQFertdWDSmfp1Devu2ARq96YStvtjSViEavWmGRWPq19mjt982Q6M3hbDVF1vaKkSjN82waEz9Onv01p72tKc97WnP13jCzckt0LI3nbDVF1vaKkR1A7YRqQiLxtSvc%2FtpibomdoOtvtjSViEavWmGRWPq17nRm7omdoOtvtjSViEavWmGRWPq17nRm7omdoOtvtjSViEavWmGRWPq1zl6Ic6Cu7fPbegNnY5VfKBLzNz8KUHVmtgLKX8YHiujpS9pELTFDrPmUK5igfiYt6xauC1wbiE%2BaYk4P6nsxgBezwg4gcFJY9VOZkr0%2BRrNUodybQt%2BdFIuxIm5ylKVOgPQq5DjVNU9qjqS7nvbMntzZ8q6w4fxKbVp4FtZBg2e8QqbXd%2FEvmj0NiPtLGPkAMSbdQKdH%2BErS9haRFuSHFSDPyg33YB7HKnMtpiDbJ%2FnJxBRFHWkciX1eJTQG3liJ9%2F94dSdTuiy7ts9Uvnz5eH%2BZdiU3kRyybVNRrwB0VUvAdkLjd4ouLNt6fs4UrO3FQJdpcJrdPALjsZq3Riw44U4q1Dg81wVSVTpjHwgvdEvMdudhuuA%2BO1mL8T5fHmYU8wNrzNle18xexsBTb0MY579pY50XQcPRPfbQQXQJeXgloFlUjsL%2B1TobgLitPPbordL7j2isdEvEEilfCm1sLcvLzgaq5S98XpGUP5dALgxIMfD%2FctLudSbspVfZZZIShMYUQpPTyZVeIx31tk2yN78uiO7Ed2rT2%2FFHlUdIr19PHZT9vbj7b57%2FtiE3vA8v3yUe6pq3nLy4l0gvK4JuCFOXtWGCoSXlIM6S%2FAHt93DGXDKelEtokxuX5Qiqu1i1Fr0ViBw9KnxVRa9Bd4O5aAZAq2YmKk%2BwKH0RgWI7OEp%2FozV5WwVvCD7KXyUEp7kjpwrHLFrCb25oQ8mAULty3yhKeqffCFOyX6AEXoDT%2FGVb%2FHsLZjnw%2FcZKNqczLM%2F04RPlcTwigXA4s%2F5q3Db%2FdWLsUit7L4ohawtdJgyeptW8TCXLhF4Lcj5GG%2Bn0kBY3XuPkj%2BEQ%2BmN8n%2FSn6NvnDCUgQVGhzoEVcIAZD6CNkoPT7lwtjFTNieBnnT25uvEZXic2EydG73NAFvBnnsUmSQ93jYK6eHUdXT2FiuAZ6fE4I%2FWKu2LNgjahg6z%2Bru3FQKn6jBjl2sJ3u6WRrAAjBNGSRJCDO723Zvn%2F4X0BpK4aPbGVXHFsDQqbLLCUy7MgDemX5kbfan7IHcjCt3qd2%2FD61339P7r51%2B%2Ffr4%2Fb%2FWHAd76Yt4mLzRIRrw5r44ve%2BNNuClq9A7UUFBgIH%2Bc579iUkBnLP8NyBmCMpl90QopltjZJMoAVPQVCcQjkaQGakuUgz4XluEIrAFZPSPI2ywJ%2FJ%2BmLtw77M9kFOO%2BXIGtqHh09BZK8wNnHKGE8PTMyBfON6Y3rnC%2BjNCbZzqS9bD4OvRW6lHVEcnevj9N6exGPy25XsF3u7MndlwaHUPWcnKo%2Brc%2BS%2FIf7k%2F0fb%2FEzFLgcu77Hv3Z3aLRXEHYlpnFhrXoMnl90QlOW9JhmMFNordigWgk4rXktsBs6cCuwmMLNXkCrRgLQKqfpHr%2Bn7rxiP3ZswemN8pWqMrY43ldiaTBl3Al4grRaeVSnC9cYkygjrw3Q3cfrQI8T5G%2Fe5Nm4OoeVR3t1JIjmjh4TTPha9BbQyKqG3DbETl2V2t3WHRv%2FTo3ejuiiUZv%2BbClrUJYoDeYzSqIkB1h0b3169zoTV0Tu8FWX2xpqxAW6O12YdGY%2BnUO6e3bBmj0phO2%2BmJLW4Vo9KYZFo2pX2eP3n7bDI3eFMJWX2xpqxCN3jTDojH16%2BzRW3va0572tKc9X%2BMJNye3QMvedMJWX2xpqxDVDdhGpCIsGlO%2Fzu2nJeqa2A22%2BmJLW4Vo9KYZFo2pX%2BdGb%2Bqa2A22%2BmJLW4Vo9KYZFo2pX%2BdGb%2Bqa2A22%2BmJLW4Vo9KYZFo2pX%2BcYvX08Tn9kOR0%2BuQG9%2BYdyXVcc6CK0gmVucxDRXkj5w%2FBYGS19SUONwU09UrlMIHLkvFq4LXBuIT5piTg%2FqezGAF7PCDiBwUlj1U5mSvT5Gs1Sh3JtC350Ui7EibnKUpU6A9CrkONU1T2qOmR6e3%2Fupmvevj8VHjuZcKSyO6bNPwQ%2F77Djq3wgZOpxt4VN7I1GbzPSBneJWnwMYehihQLdwX74yhK2FtGWJAfV4A%2FKTTfgHkcqsy3mINvn%2BQlEFEUdqVxJPcddN4kAAA3MSURBVB4l9Eae2Ml3fzh1pxO6rPt2j1R215lutjmJz%2FwGyLVNynztjj%2Fd5BKQvdDojUJscFOztxUCXaXCa3TwC47Gat0YsOOFOKtQ4PNcFUlU6Yx8IL3RLzHbnYbrgPitXYizGb2JCVq17A3LJJc%2Ba5ogDkT3paMC6JJycMvAMqmdhX0qdDcBcdr5bdFbdHBz6a1AIJXypdTC3r684GisUvZWPRZCPWfJYYBke7h%2FeSmXelO28qvMEklpAiNK4enJpAqP8c462wbZm193ZDeie%2FXprdijqiNCbw9Pjw%2FjMG3z3Rs5zy8f5Z6qGp0BF5m1QxpuiJNXtaEC4XVzoM4S%2FMFt93AGnLJeVIsok9sXpagxuHn0ViBwnNbGV1n0Fng7lIMcFK2YmKk%2BwKH0RgWI7OEp%2FozV5WwVvCD7KXyUEp6uCFk4YtcSenNDH0wChNqX%2BUJT1D%2F5QpyS%2FQAz9DZvTv54u5%2B%2BhKufvQXzfPg%2BA3K8QZm1Q3pyCmLDGUQpWwAs%2Fpy%2FCrfdX70Yi9TK7otS1Bhcid6mVTzMpUsEXgtyPsbbqTQQVvfeo%2BQP4VB6o%2Fyf9OfoGycMZWCB0aEOQZUwAJmPoI3Sw1MunG3MlM1JoCedvfk6cRkeJzZTZxv09uvjcfk5yfB6t8lPS8BWsOceRSYR4i2Uuc33DcOp6%2BjsLVYAz06JwR%2BtVdoXbagxuKnZ2wqBU3WYscu1BG93SyNYAMYJoyQJIQZ3%2B%2B7N8%2F9CegNJXDR746q4YlgaFTZZ4SkXZsAb06%2FMjb7UfZC7EYVu9bu3Xz%2Ffn7vH71tmb8H6Yt4mLzSIZG7W4fKWF3QTbooapfnD6%2B1OXM59fx7IH%2Bf5r5gU0BnLfwNyhqBMZl%2B0osbgptFbkUA8EklqoLZEOehzYRmOwBqwbiyQ%2BmD%2Fp6kL9w77Mwouui9XYCsqHh29hdL8wBlHKCE8PTPyhfON6Y0rnC8j9OaZjmQ9LL4OvZV6VHWo%2B7u34K8xsmzDtULKHKr%2Brc%2BS%2FIf7E33fLzGzFLic%2B773KnhqzhWEbZlZbFiLLpPXF52oMbhJ9FYsEI1EvJbcFpgtHdhVeGx%2FUp5AK8YCkBr%2FaUl04xH7s2cPTG%2BUrVCVscfzuhJJgy%2FhSsQVotPKpThfuMSYQB15b4buPloFeJ4if%2FcmzcDVPao62qklRzRx8Jpmwtegt4ZEVDfgtiNy7K7W7rDo3vp1bvR2RBON3vJhS1uFsEBvMJtVECE7wqJ769e50Zu6JnaDrb7Y0lYhLNDb7cKiMfXrHNLbtw3Q6E0nbPXFlrYK0ehNMywaU7%2FOHr39thkavSmErb7Y0lYhGr1phkVj6tfZo7f2tKc97WlPe77GE25OboGWvemErb7Y0lYhqhuwjUhFWDSmfp3bT0vUNbEbbPXFlrYK0ehNMywaU7%2FOjd7UNbEbbPXFlrYK0ehNMywaU7%2FOjd7UNbEbbPXFlrYK0ehNMywaU7%2FOsRsDPIznT9amN%2F9QruuKA12EVpJPaSpvYlek%2FGF4rIyWvqQha3DXHMpVLBA5cl4t3BY4txCftEScn1R2YwCvZwScwOCksWonMyX6fI1mqUO5tgU%2FOikX4sRcZalKnQHoVchxquoeVR3J2dvny0PRsZMJRyq7Y9r8Q%2FAjZ%2BhhcK1QMpdhbPRmAxmDS5zoioebdYBCge5gP3xlCVuLaEuSg2rwB%2BWmG3CPI5XZFnOQ7fP8BCKKoo5UrqQejxJ6I0%2Fs5Ls%2FnLrTCV3WfdNHKs%2FP96e7t88NNifxmd8AubZJma%2Bl07IrNbEHGr1RcGfb0vdxpGZvKwS6SoXX6OAXHI3VujFgxwtxVqHA57kqkqjSGflAeqNfYrY7DdcB8dvtXogDUrfpXtPK9CYmaNWyN15mNXojDkRfPqBvDECXlINbBpZJ7SzsU6G7CYjTzm%2BL3i6594jGHKBAIJXyJS2qkLfDjQaSxiplb7yeEWTRG3djQI6H%2B5eXcqk3ZSu%2FyiyRlCYwohSenkyq8BjvrLNtkL35dUd2I7pXn96KPao6kuhteL0ru%2Bwthd7wPL98lHuqanQGRDJr0RvcECevakMFwkvKQZ0l%2BIPb7uEMOGW9qBZRJrcvSpE%2BuLXorUDgOK2Nr7LoLfBMKAfNEGjFxEz1AQ6lNypAZA9P8WesLmer4AXZT%2BGjlPAkd%2BRc4YhdS%2BjNDX0wCRBqX%2BYLTVH%2F5AtxSvYDbNHbcqnpNtlbMM%2BH7zMgxxslsxa9TU5BbDiDKGULgMWf81fhtvurF2ORWtl9UYr0wS2jt2kVD3PpEoHXgpyP8XYqDYTVvfco%2BUM4lN4o%2Fyf9OfrGCUMZWGB0qENQJQxA5iNoo%2FTwlAtnGzNlcxLoSS%2FffZ2EJf6tZW%2FD693D648ybovSG9wK9tyjyCRCvDEyK3%2F3Npy6js7eYgXw7JQY%2FNFapX3RhozBXf3d2wqBU3WYscu1BG93SyNYAMYJoyQJIQZ3%2B%2B7N8%2F9CegNJXDR746q4YlgaFTZZ4SkXZsAb06%2FMjb7UfZC7EYVu%2Bru3H2%2F3hT8qSaI3f30xb5MXGkQyNy2zEr25KWr0Dn94vd2Jy7nvzwP54zz%2FFZMCOmP5b0DOEJTJ7ItWZAyuM12UASgHKBKIRyJJDdSWKAd9LizDEVgDsnpGkEFv2P9p6sK9w%2F6MgovuyxXYiopHR2%2BhND9wxhFKCE%2FPjHzhfGN64wrnywi9eaYjWQ%2BLr0NvpR5VHTF6%2B3jsiv4eIJnewj%2FzGU5BYp9hG64VXuY2Py2BewF93y8xsxS4nPu%2B70NtFjXnCsK2zCw2rEWXyeuLTmQN7kD%2F2U0SvRULRCMRryW3BWZLB3YVHtuflCdQSs8IsrI35P%2BpG4%2FYnz17YHqjbIWqjD2e15VIGnwJVyKuEJ1WLsX5wiXGBOrIezN099EqwPMU%2Bbs3aQau7lHV0U4tOaKJg9c0E74GvTUkoroBtx2RY3e1dodF99avc6O3I5po9JYPW9oqhAV6g9msggjZERbdW7%2FOjd7UNbEbbPXFlrYKYYHebhcWjalf55Devm2ARm86YasvtrRViEZvmmHRmPp19ujtt83Q6E0hbPXFlrYK0ehNMywaU7%2FOHr21pz3taU972vM1nnBzcgu07E0nbPXFlrYKUd2AbUQqwqIx9evcflqirondYKsvtrRViEZvmmHRmPp1bvSmrondYKsvtrRViEZvmmHRmPp1bvSmrondYKsvtrRViEZvmmHRmPp1jtDb8Ho3%2Fo1l8anKuYdyXVcc6CK0gmWiZtc2sStS%2FjA8VkZLX9JQNrgFh3IVC8QelVWL9UzhUC7%2FKSyGwN4PSPgBAYnjVU7mSnR52s0Sx3KtS340Um5ECfmKktV6gxAr0KOU1X3qOoQ6e3z5WG6Cuf9udvmtm5wpqw7fBifUpsGrhVCpjuGLe%2FwHy2U0OhtRtpZxkvU4mMIw9EvFIg9KqFWkmcmHqlcPNw7HKnMtpiDbJ%2FnJxBRFHWkciX1eJTQG3liJ9%2F94dSdTuiy7ts9Uhlc0v39qSu70TR6IY5w%2BE6ubVLmaySzbkjvhUZvFNzZtvR9HKnZ2wqBrlLhNTr4BUdjtW4M2PFCnFUo8HmuiiSqdEY%2BkN7ol5jtTsN1QPx2uxfiLLfhlN9oGr%2FOlO19texNkpnZiNSRruvggejLB%2FSNAeiScnDLwDKpnYV9KnQ3AXHa%2BW3R2yX3HtFY9BUIpFK%2BlFqCZ3I0Vil74%2FWMIIveuBsDcjzcv7yUS70pW%2FlVZomkNIERpfD0ZFKFx3hnnW2D7M2vO7Ib0b369FbsUdUR%2B2nJ58tD13WlO5Mp9Ibn%2BeWj3FNVozNgIHN0whoMCjfEyavaUIHwknJQZwn%2B4LZ7OANOWS%2BqRZTJ7YtSpA9uLXorEAg9KoveJM8MZwi0YmKm%2BgCH0hsVILKHp%2FgzVpezVfCC7KfwUUp4uiJk4YhdS%2BjNDX0wCRBqX%2BYLTVH%2F5AtxSvYDjNCb25wsv9Q0nr0F83z4PgNyvDEy89I3ponJKYgNZxClbAGw%2BHP%2BKtx2f%2FViLFIruy9KkT64ZfQ2reJhLl0i8FqQ80U8Myl7i7vxofRG%2BT%2Fpz9E3ThjKwAKjQx2CKmEAMh9BG6WHp1w425gpm5NATzp783XiMjxObKbONuhteL1bfjAJ%2F12R3uBWsOceRSYR4k2QWTGkh1PX0dlbrACenRKDP1qrtC%2FakDG4q797WyFwqg4zdrlW3DODcYRxwihJQojB3b578%2Fy%2FkN5AEhfN3rgqrhiWRoVNVnjKhRnwxvQrc6MvdR%2FkbkShm%2F3u7eOxc9nbNj8t8dcX8zZ5oUEkc7PfuNXI3twUNXqHP7ze7sTl3Pfngfxxnv%2BKSQGdsfw3IGcIymT2RSvSB9ffkpEZgIq%2BIoGER6WokeKZXJbGLtVpsAZk9Ywgg96w%2F9PUhXuH%2FRkFF92XK7AVFY%2BO3kJpfuCMI5QQnp4Z%2BcL5xvTGFc6XEXrzTEeyHhZfh95KPao6It%2B9fX%2Ba89mn9wJuS6C38M98gr%2FGyLIN1wopc3lZpYkl%2BQ%2F3J%2Fq%2BX2JmKXA5933fh837GpF5mJPSg%2Fj0BRFl8vqiE2WD60%2F4SfRWLBB7VLRWkmf6G0vsKjy2UJMnUErPCLKyN%2BT%2FqRuP2J89e2B6o2yFqow9nteVSBp8CVcirhCdVi7F%2BcIlxgTqyHszdPfRKsDzFPm7N2l6rO5R1dFOLTmiiYPXNBO%2BBr01JKK6AbcdkWN3tXaHRffWr%2FP%2FAz6hUhNIRLh%2FAAAAAElFTkSuQmCC&refer=http%3A%2F%2Fwww.cnblogs.com%2Flori%2Fp%2F3303550.html" class="lazy" alt="知方可补不足~sqlserver中使用sp" ><br>
下面对status执行状态作一个简单的说明,选自MSDN
background:会话正在运行一个后台任务,例如死锁检测。
rollback: 会话具有正在处理的事务回滚。
pending: 会话正在等待工作线程变为可用。
runnable: 会话的任务在等待获取时间量程时位于计划程序的可运行队列中。
spinloop: 会话的任务正在等待调节锁变为可用。
suspended: 会话正在等待事件(如 I/O)完成。
注意:如果你的代码处理数据比较大,SQL会创建子线程进行并行处理,子线程的标示为ecid。
别外,如果希望查看SQL进程的详细信息,可以使用下面代码
SELECT * FROM sys.sysprocesses
查看被锁住的对象,可以使用下面代码
SELECT * FROM sys.syslockinfo
如果希望查看指定会话(SQL进程)的语句(从客户端发过来的SQL语句),可以使用下面语句
dbcc inputbuffer(Session_ID)
如果希望查看正在被阻塞的语句(sysprocesses的blocked),可以使用下面语句
dbcc inputbuffer(Blocked)
回到目录

핫 AI 도구

Undresser.AI Undress
사실적인 누드 사진을 만들기 위한 AI 기반 앱

AI Clothes Remover
사진에서 옷을 제거하는 온라인 AI 도구입니다.

Undress AI Tool
무료로 이미지를 벗다

Clothoff.io
AI 옷 제거제

AI Hentai Generator
AI Hentai를 무료로 생성하십시오.

인기 기사

뜨거운 도구

메모장++7.3.1
사용하기 쉬운 무료 코드 편집기

SublimeText3 중국어 버전
중국어 버전, 사용하기 매우 쉽습니다.

스튜디오 13.0.1 보내기
강력한 PHP 통합 개발 환경

드림위버 CS6
시각적 웹 개발 도구

SublimeText3 Mac 버전
신 수준의 코드 편집 소프트웨어(SublimeText3)

뜨거운 주제











SQL Server 데이터베이스에 이미 존재하는 동일한 이름을 가진 개체의 경우 다음 단계를 수행해야 합니다. 개체 유형(테이블, 뷰, 저장 프로시저)을 확인합니다. IF NOT EXISTS를 사용하면 객체가 비어 있는 경우 생성을 건너뛸 수 있습니다. 개체에 데이터가 있는 경우 다른 이름을 사용하거나 구조를 수정하세요. 기존 개체를 삭제하려면 DROP을 사용하세요. 주의하세요. 백업을 권장합니다. 삭제되거나 이름이 바뀐 개체에 대한 참조가 없는지 확인하려면 스키마 변경 사항을 확인하세요.

가져오기 단계는 다음과 같습니다. MDF 파일을 SQL Server의 데이터 디렉터리(일반적으로 C:\Program Files\Microsoft SQL Server\MSSQL\DATA)에 복사합니다. SSMS(SQL Server Management Studio)에서 데이터베이스를 열고 연결을 선택합니다. 추가 버튼을 클릭하고 MDF 파일을 선택합니다. 데이터베이스 이름을 확인하고 확인 버튼을 클릭합니다.

SQL Server 서비스가 시작되지 않는 경우 해결해야 할 몇 가지 단계는 다음과 같습니다. 오류 로그를 확인하여 근본 원인을 확인합니다. 서비스 계정에 서비스를 시작할 수 있는 권한이 있는지 확인하세요. 종속성 서비스가 실행 중인지 확인하세요. 바이러스 백신 소프트웨어를 비활성화합니다. SQL Server 설치를 복구합니다. 복구가 작동하지 않으면 SQL Server를 다시 설치하십시오.

SQL Server 포트 번호를 보려면 SSMS를 열고 서버에 연결합니다. 개체 탐색기에서 서버 이름을 찾아 마우스 오른쪽 단추로 클릭하고 속성을 선택합니다. 연결 탭에서 TCP 포트 필드를 확인하세요.

실수로 SQL Server 데이터베이스를 삭제한 경우 다음 단계를 수행하여 복구할 수 있습니다. 데이터베이스 활동 중지, 데이터베이스 로그 확인, 백업에서 복원, DBCC CHECKDB 사용 파티 도구. 데이터 손실을 방지하려면 데이터베이스를 정기적으로 백업하고 트랜잭션 로깅을 활성화하십시오.

SQL Server 데이터베이스 파일은 일반적으로 다음 기본 위치에 저장됩니다. Windows: C:\Program Files\Microsoft SQL Server\MSSQL\DATALinux: /var/opt/mssql/data 데이터베이스 파일 경로를 수정하여 데이터베이스 파일 위치를 사용자 정의할 수 있습니다. 환경.

SQL Server 설치가 실패하면 다음 단계에 따라 정리할 수 있습니다. SQL Server 제거 레지스트리 키 삭제 파일 및 폴더 삭제 컴퓨터를 다시 시작합니다.

오늘날 클라우드 스토리지는 우리의 일상 생활과 업무에 없어서는 안 될 부분이 되었습니다. 중국 최고의 클라우드 스토리지 서비스 중 하나인 Baidu Netdisk는 강력한 스토리지 기능, 효율적인 전송 속도 및 편리한 운영 경험으로 많은 사용자의 호감을 얻었습니다. 중요한 파일을 백업하고, 정보를 공유하고, 온라인으로 비디오를 시청하고, 음악을 듣고 싶은 경우 Baidu Cloud Disk는 귀하의 요구를 충족할 수 있습니다. 그러나 많은 사용자가 Baidu Netdisk 앱의 구체적인 사용 방법을 이해하지 못할 수 있으므로 이 튜토리얼에서는 Baidu Netdisk 앱 사용 방법을 자세히 소개합니다. Baidu 클라우드 네트워크 디스크 사용 방법: 1. 설치 먼저 Baidu Cloud 소프트웨어를 다운로드하고 설치할 때 사용자 정의 설치 옵션을 선택하십시오.
