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

ÓйØSQL server2005

ÔõôÓ𡣿²éѯ·ÖÎöÆ÷¶¼ÕÒ²»µ½..555

Â¥Ö÷±ð¼±ÂýÂýÀ´¡£¸Õ½Ó´¥ÐÂÈí¼þ¶¼ÕâÑù¡­¡­

¿´×ŽçÃæÆ«×óÉÏÄÇÀïÓÐÒ»¸ö°´Å¥ÊÇ¡°Ð½¨²éѯ¡±  È»ºóÑ¡ÔñÁ¬½Ó  ¾Í¿ÉÒÔÁË

²éѯ·ÖÎöÆ÷,Äãµã¿ª¾ÍÌáʾÁ¬½Ó,ĬÈÏÊÇLOCALÖ±½ÓÁ¬½Óѽ,È»ºóÑ¡ÔñÊý¾Ý¿â,д²éѯѽ

´ò¿ª
SQL SERVER MANAGEMENT STUDIO

¿ªÊ¼²Ëµ¥µÄ Microsoft SQL Server 2005 ÏÂÃæÓиö SQL Server Management Studio

¶¼ÊÇÇ¿ÈË.ɶ¶¼¶®.

ҪôûװSQL2005¿Í»§¶Ë¹¤¾ß

×°Á˵ϰֱ½ÓÆô¶¯SSMS


Ïà¹ØÎÊ´ð£º

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

¹ØÓÚDelphiʹÓÃADOÁ¬½ÓSQL server 2000Êý¾Ý¿âµÄÎÊÌâ

СµÜÎÒÓÃADOÁ¬½ÓSQL server 2000Êý¾Ý¿â£¬È»ºóÔÚDBGridÖÐÏÔʾ£¬ÏÖÔÚÏë°ÑÔÚDBGridÖвéѯµ½µÄÊý¾ÝiPlot×÷ͼ£¬ÇëÎÊÈçºÎʵÏÖÔÚDBGridÖеÄÊý¾Ý¶ÁÈ¡£¬¶Á³öµÄÊý¾ÝÊÇSTRINGÀàÐ͵ģ¬ÈçºÎÓÐЧµÄת±ä³ÉÊý¾Ý¿âÖÐËù´æ´¢µÄDOUBLEÀàÐ ......

OracleÖвéѯ×òÌì00£º00µ½½ñÌì00£º00µÄsqlÔõôд£¿

ÔÚOracleÖУ¬ÎÒÏë²éϵͳʱ¼äÒ»ÌìµÄÊý¾Ý£¬Ê¹ÓÃÕâ¸öÓï¾ä
select * from tablename
where create_time>SYSDATE-1
and create_time <SYSDATE


ÎÒÏë²é×òÌì00£º00µ½½ñÌì00£º00µÄsqlÔõôд£¬
» ......

ÇóÒ»¸ösqlÓï¾ä

A±í          B±í
WZID WZJG    WZID  CKID WZSL
ÏÖÔÚÒª²é¶ÔÓ¦µÄÿһ¸öCKIDϵÄ×ܵĽð¶î
¾ÍÊÇÏȲéÿ¸öWUIDÔÚB±íÀïµÄÊýÁ¿£¬È»ºóÓÃWZJG*sum(wzsl)£¬È»ºóÔÙ°´ÕÕÿ¸ ......

SqlÅÅÐò - MS-SQL Server / »ù´¡Àà

ÎÒµÄTblworkbill±íµÄÊý¾ÝÈçÏÂ:
id workbillno ..................
1 1
2 6
3 a1
4 c2
5 2
6 aa
7 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ