Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Sql Server µÈ´ý״̬˵Ã÷

µÈ´ýÀàÐÍ  ˵Ã÷  
ASYNC_DISKPOOL_LOCK 
µ±³¢ÊÔͬ²½²¢ÐеÄỊ̈߳¨Ö´Ðд´½¨»ò³õʼ»¯ÎļþµÈÈÎÎñ£©Ê±³öÏÖ¡£ 
ASYNC_IO_COMPLETION 
µ±Ä³ÈÎÎñÕýÔڵȴý I/O Íê³Éʱ³öÏÖ¡£ 
ASYNC_NETWORK_IO 
µ±ÈÎÎñ±»×èÖ¹ÔÚÍøÂçÖ®ºóʱ³öÏÖÔÚÍøÂçдÈëÖС£ 
BACKUP 
µ±ÈÎÎñ×÷Ϊ±¸·Ý´¦ÀíµÄÒ»²¿·Ö±»×èֹʱ³öÏÖ¡£ 
BACKUP_OPERATOR 
µ±ÈÎÎñÕýÔڵȴý´Å´ø×°Èëʱ³öÏÖ¡£ÈôÒª²é¿´´Å´ø״̬£¬Çë²éѯ sys.dm_io_backup_tapes¡£Èç¹û×°Èë²Ù×÷ûÓйÒÆð£¬Ôò¸ÃµÈ´ýÀàÐÍ¿ÉÄÜָʾ´Å´ø»ú·¢ÉúÓ²¼þÎÊÌâ¡£ 
BACKUPBUFFER 
ÔÚ±¸·ÝÈÎÎñµÈ´ýÊý¾Ý»òµÈ´ýÓÃÀ´´æ´¢Êý¾ÝµÄ»º³åÇøʱ·¢Éú¡£´ËÀàÐͲ»³£¼û£¬Ö»Óе±ÈÎÎñµÈ´ý×°Èë´Å´øʱ²Å»á³öÏÖ¡£ 
BACKUPIO 
ÔÚ±¸·ÝÈÎÎñµÈ´ýÊý¾Ý»òµÈ´ýÓÃÀ´´æ´¢Êý¾ÝµÄ»º³åÇøʱ·¢Éú¡£´ËÀàÐͲ»³£¼û£¬Ö»Óе±ÈÎÎñµÈ´ý×°Èë´Å´øʱ²Å»á³öÏÖ¡£ 
BACKUPTHREAD 
µ±Ä³ÈÎÎñÕýÔڵȴý±¸·ÝÈÎÎñÍê³Éʱ³öÏÖ¡£µÈ´ýʱ¼ä¿ÉÄܽϳ¤£¬´Ó¼¸·ÖÖÓµ½¼¸¸öСʱ¡£Èç¹û±»µÈ´ýµÄÈÎÎñÕý´¦ÓÚ I/O ½ø³ÌÖУ¬Ôò¸ÃÀàÐͲ»Ö¸Ê¾·¢ÉúÎÊÌâ¡£ 
BAD_PAGE_PROCESS 
µ±ºǫ́´íÎóÒ³¼Ç¼Æ÷ÕýÔÚ³¢ÊÔ±ÜÃâÿ¸ôÎåÃëÒÔÉϵÄʱ¼äÔËÐÐʱ³öÏÖ¡£ 
BROKER_RECEIVE_WAITFOR 
µ± RECEIVE WAITFOR ÕýÔڵȴýʱ³öÏÖ¡£Èç¹ûûÓÐ×¼±¸½ÓÊÕµÄÏûÏ¢£¬Ôòͨ³£³öÏÖ¸Ã״̬¡£ 
BROKER_TRANSMITTER 
µ± SQL Server 2005 Service Broker ´«Êä´úÂëÖгöÏַdz£¶ÌÔݵĵȴýʱ³öÏÖ¡£ 
BROKER_SHUTDOWN 
µ±°´¼Æ»®¹Ø±Õ Service Broker ʱ³öÏÖ¡£¸Ã״̬³öÏÖµÄʱ¼äÓ¦µ±¾¡Á¿¶ÌÔÝ¡£ 
BROKER_MASTERSTART 
µ±Ä³ÈÎÎñÕýÔڵȴý Service Broker µÄÖ÷ʼþ´¦Àí³ÌÐòÆô¶¯Ê±³öÏÖ¡£¸Ã״̬³öÏÖµÄʱ¼äÓ¦µ±·Ç³£¶ÌÔÝ¡£ 
BROKER_EVENTHANDLER 
µ±Ä³ÈÎÎñÕýÔÚ Service Broker µÄÖ÷ʼþ´¦Àí³ÌÐòÖеȴýʱ³öÏÖ¡£³öÏÖʱ¼äÓ¦¸Ã·Ç³£¶ÌÔÝ¡£ 
BROKER_REGISTERALLENDPOINTS 
ÔÚ³õʼ»¯ Service Broker Á¬½Ó¶ËµãµÄ¹ý³ÌÖгöÏÖ¡£³öÏÖʱ¼äÓ¦¸Ã·Ç³£¶ÌÔÝ¡£ 
BROKER_INIT 
µ±³õʼ»¯Ã¿¸ö»î¶¯Êý¾Ý¿âÖÐµÄ Service Broker ʱ³öÏÖ¡£¸Ã״̬²»Ó¦µ±Æµ·±³öÏÖ¡£ 
BUILTIN_HASHKEY_MUTEX 
½ö¹©ÄÚ²¿Ê¹Óᣠ
CHKPT 
ÔÚ·þÎñÆ÷Æô¶¯Ê±³öÏÖÒÔ֪ͨ¼ì²éµãÏ߳̿ÉÒÔÆô¶¯¡£ 
CLR_AUTO_EVENT 
µ±Ä³ÈÎÎñµ±Ç°ÕýÔÚÖ´Ðй«¹²ÓïÑÔÔËÐÐʱ (CLR) Ö´Ðв¢ÇÒÕýÔڵȴýÌØÊâµÄ×Ô¶¯Ê¼þÆô¶¯Ê±³öÏÖ¡£ 


Ïà¹ØÎĵµ£º

java±¸·Ýsql serverÊý¾Ý¿â ´æ´¢¹ý³Ì

½ñÌì¸ø´ó¼Ò·ÖÏíÒ»ÏÂÈçºÎ±¸·ÝºÍ»Ø¸´sql server Êý¾Ý£¬
Ê×ÏÈÈ·±£Äã¾ßÓÐDBµÄ×î¸ßȨÏÞ
ÔÚJAVA´úÂëÖÐ Äã¿ÉÒÔÕâÑùдpublic class Opp extends TestCase{
public void test1()
{
try
{
Connection con = DBUtils.getConn();
String sql="backup database tdzl to disk='d:\\tdzl.bak'";
Statement st = con.c ......

Oracle¶¯Ì¬SQLÓï¾ä


ÔÚʹÓÃODP.NET½øÐÐOracle±à³Ìʱ£¬ÓÐʱºòSQLÓï¾ä·Ç³£¸´ÔÓ£¬ÐèÒª²ÉÓö¯Ì¬¹¹Ôì²éѯÓï¾äµÄÇé¿ö£¬ÓÐÁ½ÖÖ·½·¨¿ÉÒÔ¹¹Ô춯̬µÄSQLÓï¾ä£¬²¢Ö´Ðзµ»Ø½á¹û¼¯¡£
1¡¢ÔÚÊý¾Ý·ÃÎʲ㹹ÔìSQLÓï¾ä
ÀýÈçÏÂÃæµÄÓï¾ä£¬½«¹¹ÔìÍêÕûµÄSQLÓï¾ä¸³Öµ¸øCommandText£¬ÔÙ´«µÝµ½Êý¾Ý¿â½øÐÐÖ´ÐУ¬·µ»Ø½á¹û¼¯¡£
loadCommand.CommandType = Com ......

[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(¶þ)

±¾ÏµÁÐÎÄÕµ¼º½
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(Ò»)--sum()
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(¶þ)--max()
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(Èý)--row_number() /rank()/dense_rank()
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(ËÄ)--lag()/lead()
Èç¹ûÎÒÃÇ°´ÕÕʾÀýÏëµÃµ½Ã¿¸ö²¿ÃÅнˮֵ×î¸ßµÄ¹ÍÔ±µÄ¼Í¼£¬¿ÉÒÔÓÐËÄÖÖ·½·¨ÊµÏÖ£ ......

[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(Èý)

±¾ÏµÁÐÎÄÕµ¼º½
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(Ò»)--sum()
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(¶þ)--max()
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(Èý)--row_number() /rank()/dense_rank()
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(ËÄ)--lag()/lead()
ÓÐЩʱºòÎÒÃÇÏ£ÍûµÃµ½Ö¸¶¨Êý¾ÝÖеÄÇ°nÁУ¬Ê¾ÀýÈçÏ£º
µÃµ½Ã¿¸ö²¿ÃÅнˮ×î¸ßµÄ ......

DB2 SQL ¾«Òª £¨³ÖÐø¸üÐÂÖÐ.......£©

----start
      ·²ÊÇÖªµÀÊý¾Ý¿âµÄÈ˶¼ÖªµÀSQL£¬·²ÊǶÔSQLÓÐÒ»µãÁ˽âµÄÈ˶¼¾õµÃSQLºÜ¼òµ¥£¬·²ÊÇÓÐÕâÖָоõµÄÈ˶¼ÊÇSQLµÃ³õ¼¶Óû§£¬ÒòΪËûѧ»áÁËÔö²éɾ¸Ä¾ÍÒÔΪÕâ¾ÍÊÇSQLµÄÈ«²¿¡£Ä¿Ç°µÄ´ó²¿·ÖÓ¦ÓÃÈí¼þ¶¼ÊÇÒÔÊý¾Ý¿âΪÖÐÐÄ£¬Ëæ×ÅÈí¼þµÄÔËÐУ¬Êý¾ÝÁ¿»áÔ½À´Ô½´ó¡£ÈçºÎÓüò½à¡¢¸ßЧµÄSQLÓï¾ä²Ù×÷Êý¾ÝÏÔµÃÔ½À ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ