µç»°±¾Æ¥Åä²éѯ£¬Ï£ÍûÒ»ÌõÓï¾ä¸ã¶¨
¼ÙÉèºÅÂë±¾(numtable)ÈçÏÂ:
ºÅÂë(num) ÁªÏµÈË (relationname)
10086 ÒÆ¶¯¿Í·þ
110 ±¨¾¯
8776532 ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
±ísinger£º
singerID£¬singerName
1£¬ÁõµÂ»ª
2£¬ÕÅѧÓÑ
3£¬¹ù¸»³Ç
4£¬ÀèÃ÷
±ísong£º
songID£¬songName£¬singerID
1£¬ÍüÇéË®£¬1
2£¬ÖйúÈË£¬1
3£¬ÎDZð£¬2
4£¬¶ÔÄã°®²»Í꣬3
5£¬½ñÒ¹Äã»á²»»áÀ´£¬4
ÎÒÏë²éÕÒÁõµÂ»ªµÄ¸èÇú£¬ÓÐÁ½ÖÖsqlÓï¾ä£º
1.Á½±íÁ¬½Ó
C# code:
sele ......
ÇëÎÊÈçºÎÔÚSQLSERVERÖвâÊÔ²¢µÃµ½SQLÓï¾äÔËÐÐʱ¼ä£¿
лл£¡
SQL code:
SET STATISTICS TIME ON
...sql
SET STATISTICS TIME off
ÎÒÊÇ¿´Ê±¼ä¸ú×ÙÆ÷¸ú×ÙsqlµÄÖ´ÐÐʱ¼ä Duration ÁÐ
ѧϰÁË
ÒýÓÃ
ÇëÎÊÈçºÎÔÚSQLSERVERÖвâÊÔ²¢µÃµ½SQLÓï¾äÔËÐÐʱ¼ä£¿
лл£¡
ÒýÓÃ
SQL codeSETSTATIST ......
½ñÌìÍøÉÏ¿´Ò»¸öÏîÄ¿£¨sqlserver£«¡£net£©·¢ÏÖËûµÄsqlÈ«²¿Óô洢¹ý³ÌʵÏÖ
ÕâÀïÓкܴóµÄÒÉÎÊ¡£
Èç¹ûÊÇСÏîÄ¿£¬½ö½ö¹©Ð¡team¼¸¸öÈËÓã¬ÊÇÎÞËùνµÄ
Èç¹û²¢·¢Óû§ÊýÊǺܴóµÄ
½¨ÒéÓÃweb·þÎñÆ÷À´Ôö¼Ó¸ºÔØ£¬²»Ó¦¸ÃÔÙÓô洢¹ý³Ì¡£
¿Í»§¶ËʵÏÖ²¿·ÖµÄ¼ÆËã¹ý³Ì¡£
¿ÉÒÔÕâÑù×öÂð¡¡¡¡£¨À§»óµÄÊǼ´Ê¹web·þÎñÆ÷³ÌÐòÔ´´úÂëÔ ......
SqlServerÀïÒÑÓÐÒ»¸ö±í¸ñ×Ö¶ÎΪAºÍB£¬
excelÀïµÄÊý¾ÝÈçÏÂ
ÈçͼËùʾ£¬ÓÐһЩµ¥Ôª¸ñÊǺϲ¢µÄ£¬ÕâÖÖÇé¿öÒªÈçºÎдSQL°¡
×Ô¼º¶¥Ï£¡
ÕâÑù²»ÐаÉ
°ÑºÏ²¢µÄ¸ø·Ö¿ª°É
SQL code:
SELECT *
from openrowset('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE=c:\aa.xls','select * from [sheet1 ......