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

ÇóSQLÓï¾äÓÅ»¯¹¤¾ß£¿

ÇóSQLÓï¾äÓÅ»¯¹¤¾ß£¿
Õë¶ÔSQL ServerµÄ
·¢Ë͵½ÎÒÓÊÏäsclsmile@163.com
»òÕ߸øÎÒÒ»¸öÍøÖ·Á´½Ó
¹Ø×¢¡£

http://www.net130.com/class/oracle_datum_soft/Embarcadero%20SQLTuner%202.0.2.rar

http://space.itpub.net/?uid-16436858-action-viewspace-itemid-520854

http://www.net130.com/CMS/Pub/oracle/oracle_material/oracle_material_soft/173530.htm

ºÇºÇ,ÍøÕ¾ÉϵÄ,ûÓùý

»¹ÓÐÕ⹤¾ß,Ë­ÓÐ?Ò²¸øÎÒÒ»¸ö.

ÒýÓÃ
»¹ÓÐÕ⹤¾ß,Ë­ÓÐ?Ò²¸øÎÒÒ»¸ö.

ºÇºÇ


Ïà¹ØÎÊ´ð£º

ÇósqlÓï¾ä

×Ö¶Îaa,¹²ÓÐ178¸öÊý¾Ý,ÏÔʾʱÊÇÒ»ÁÐÖ±ÅÅÏÂÀ´µÄ,ÎÒÏëÈÃÕâ178¸öÊý¾Ý,ÿÁÐÖ»ÏÔʾ5¸ö,¶àÁÐÏÔʾÍê,ÈçºÎʵÏÖ?

¼ÓÒ»¸öIDENTITYTÁÐ,°´ID%5À´·Ö

ÒýÓÃ
¼ÓÒ»¸öIDENTITYTÁÐ,°´ID%5À´·Ö

ID-1/5À´·Ö


SQL co ......

¹ØÓÚgroup byµÄsqlÓï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

delphiÖÐexcelµ¼Èësql serverµÄÎÊÌâ¡£

'Select * into mytable from OpenDataSource(''Microsoft.JET.OLEDB.4.0'',''Data Source=f:\test.xls;Mode=Read;Extended Properties=Excel 5.0;Persist Security Info=False' ......

¾Ý˵SQLÓиö±à¼­Æ÷£¬²»ÖªÈçºÎʹÓ÷¨£¬ÔÚʲôµØ·½£¿

ÒªÊäÈëUSE <Êý¾Ý¿âÃû>ʱ£¬ÒªÓõ½SQL±à¼­Æ÷£¬µ«²»ÖªµÀÔÚʲôµØ·½£¬¸ßÊÖ°ï°ïæѽ£¡

SQL2005  µã»÷ÓÒÉϽǵÄ--н¨²éѯ(N)

Êó標選擇Òª²é詢µÄ數據庫£¬È»á ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ