Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : sqlserver

sqlserver jdbc driverÇý¶¯ÄÄÀïÕÒ

ÎÒ´Ó΢Èí¹ÙÍøÏÂÔصÄdriverÔõôÊǸöhtmlÎļþË­¸øÖ¸Õýһϣ¬ÔÚÄÄÀïÏ£¬¾ßÌå·¾¶¼°²Ù×÷²½Öè
Ò»°ã¹ÜÍøÏÂÔض¼ÒªÒ»²½Ò»²½×ßÏÂÈ¥£¬Èç¹ûÄã¹ýÔçÁí´æΪµÄ»°£¬µÃµ½µÄÍùÍùÊÇlicenseÄÇÒ»Ò³¡£

ÎҼǵĺÃÏëÔÚ£ºÄãϵÄÄǸöHTMLÎļþÊÇЭÒ飺ÔÚÀïÃæÓÐÏÂÔصØÖ·£»


ÏñÕâÖÖÎÊÌ⣬¥Ö÷ÍêÈ«¿ÉÒÔ°Ù¶ÈÖ®ÀàµÄ¾Í¿ÉÒÔÕÒµ½¡£

ÒÔºóҪѧ»á·½· ......

ÇëÎÊÈçºÎÔÚSQLSERVERÖвâÊÔ²¢µÃµ½SQLÓï¾äÔËÐÐʱ¼ä£¿

ÇëÎÊÈçºÎÔÚSQLSERVERÖвâÊÔ²¢µÃµ½SQLÓï¾äÔËÐÐʱ¼ä£¿

лл£¡
SQL code:

SET STATISTICS TIME ON
...sql
SET STATISTICS TIME off

ÎÒÊÇ¿´Ê±¼ä¸ú×ÙÆ÷¸ú×ÙsqlµÄÖ´ÐÐʱ¼ä Duration ÁÐ

ѧϰÁË
ÒýÓÃ
ÇëÎÊÈçºÎÔÚSQLSERVERÖвâÊÔ²¢µÃµ½SQLÓï¾äÔËÐÐʱ¼ä£¿

лл£¡


ÒýÓÃ
SQL codeSETSTATIST ......

Óг¥ÇósqlserverÊý¾Ý¿âÉè¼Æ:ÓÐÏßµçÊÓ

ÐèҪʹÓÃSQL Server2000»ò2005
ÐèÒªÉè¼ÆÊý¾ÝÓÐЧÑéÖ¤,·Àֹ¼Èë²»ºÏ·¨Êý¾Ý
ÐèÒªÉè¼Æ´æ´¢¹ý³Ì»ò×Ô¶¨Ò庯ÊýÍê³ÉÊý¾ÝµÄ¼Èë\ÐÞ¸Ä\ɾ³ý\ͳ¼Æ\²éѯ

Êý¾Ý¿â´ó²¿·Ö±íÎÒÒѾ­½¨Á¢,Ö»ÊǸ¨ÖúÐÔµÄС±í½¨Á¢µÄ»¹²»È«
¸´ÔÓÖ®´¦ÔÚÓÚ,Ðí¶à±íµÄĬÈÏÖµºÍÈ¡Öµ¼¯ºÏÐèÒªÓÉÆäËü±íÖеÄÊý¾Ý¾ö¶¨
ÁíÍâ¸÷´æ´¢¹ý³ÌÒª·µ»Ø¸÷ÖÖÇé¿öϵij ......

SQLSERVERÄÜ»ñµÃÁ¬½ÓµÄÓû§µÄIPÂð£¿

SQL SERVERÄÜ»ñµÃÁ¬½ÓµÄÓû§µÄIPÂð£¿

Ö÷ÒªÏëʵÏÖÒÔÏ£º
Ò»¸öÓû§Á¬½Óµ½Êý¾Ý¿â£¬°ÑÓû§µÄÓû§ÃûÓëIP¶¼±£´æÔÚÊý¾Ý¿âÖУ¬À´ÊµÏÖÓû§µÇ¼µÄ¹¦ÄÜ¡£
×îºÃÊÇÓû§µ÷ÓÃÒ»¸ö´æ´¢¹ý³Ì£¬°ÑÓû§Ãû×÷²ÎÊý£¬´æ´¢¹ý³Ì¾ÍÄÜ°ÑÓû§µÄÓû§ÃûÓëIP±£´æÏÂÀ´¡£

ÇëÖ¸½Ì£¨Ö»ÓÐ16·ÖÁË£©
SQL code:
if exists (select * ......

ado·ÃÎÊÔ¶³ÌÊý¾Ý¿â(Ô¶³Ì·ÃÎÊsqlserver)

ÊÇÕâÑùµÄ£¬ÎÒÓÃÊÇODBCÊý¾ÝÔ´Á¬½Ó·þÎñÆ÷µÄÊý¾Ý¿â£¬ÏÖÔÚÎÒ¾õµÃºÜÂé·³£¬ÒòΪҪΪÿÈç»úÌí¼Ó¶ÔÓ¦µÄÊý¾ÝÔ´£¬Ïë°ÑËû¸Ä³ÉADO·½·¨À´·ÃÎÊ·þÎñÆ÷µÄÊý¾Ý¿âÄÜʵÏÖÂð£¿ÒªÔõôд¡£
±ÈÈç·þÎñÆ÷ÀïÓжþ¸öÊý¾Ý¿âdata1 ºÍdata2£¬¿Í»§¶ËÕâ±ßÎÒÉÏÓÃACESSS\vbaÀ´×ö³ÌÐò£¬ÒªÔõô²ÅÄÜÁ¬½Ó·ÃÎʵ½ÎÒ·þÎñÆ÷ÀïÃæµÄÁ½¸öÊý¾Ý¿âµÄÊý¾ÝÄØ£¿Ð»Ð»
http://h ......

sqlserverÏ´óÐÍÍøÕ¾µ½µ×ÊÇÓÃsqlÓï¾ä»¹ÊÇÔÚ´æ´¢¹ý³ÌºÃ

½ñÌìÍøÉÏ¿´Ò»¸öÏîÄ¿£¨sqlserver£«¡£net£©·¢ÏÖËûµÄsqlÈ«²¿Óô洢¹ý³ÌʵÏÖ
ÕâÀïÓкܴóµÄÒÉÎÊ¡£
Èç¹ûÊÇСÏîÄ¿£¬½ö½ö¹©Ð¡team¼¸¸öÈËÓã¬ÊÇÎÞËùνµÄ
Èç¹û²¢·¢Óû§ÊýÊǺܴóµÄ
½¨ÒéÓÃweb·þÎñÆ÷À´Ôö¼Ó¸ºÔØ£¬²»Ó¦¸ÃÔÙÓô洢¹ý³Ì¡£
¿Í»§¶ËʵÏÖ²¿·ÖµÄ¼ÆËã¹ý³Ì¡£
¿ÉÒÔÕâÑù×öÂð¡¡¡¡£¨À§»óµÄÊǼ´Ê¹web·þÎñÆ÷³ÌÐòÔ´´úÂëÔ ......
×ܼǼÊý:322; ×ÜÒ³Êý:54; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [40] [41] [42] [43] 44 [45] [46] [47] [48] [49]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ