ÓйØSQL server2005
ÔõôÓ𡣿²éѯ·ÖÎöÆ÷¶¼ÕÒ²»µ½..555
Â¥Ö÷±ð¼±ÂýÂýÀ´¡£¸Õ½Ó´¥ÐÂÈí¼þ¶¼ÕâÑù¡¡
¿´×ŽçÃæÆ«×óÉÏÄÇÀïÓÐÒ»¸ö°´Å¥ÊÇ¡°Ð½¨²éѯ¡± È»ºóÑ¡ÔñÁ¬½Ó ¾Í¿ÉÒÔÁË
²éѯ·ÖÎöÆ÷,Äãµã¿ª¾ÍÌáʾÁ¬½Ó,ĬÈÏÊÇLOCALÖ±½ÓÁ¬½Óѽ,È»ºóÑ¡ÔñÊý¾Ý¿â,д²éѯѽ
´ò¿ª
SQL SERVER MANAGEMENT STUDIO
¿ªÊ¼²Ëµ¥µÄ Microsoft SQL Server 2005 ÏÂÃæÓиö SQL Server Management Studio
¶¼ÊÇÇ¿ÈË.ɶ¶¼¶®.
ҪôûװSQL2005¿Í»§¶Ë¹¤¾ß
×°Á˵ϰֱ½ÓÆô¶¯SSMS
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
СµÜÎÒÓÃADOÁ¬½ÓSQL server 2000Êý¾Ý¿â£¬È»ºóÔÚDBGridÖÐÏÔʾ£¬ÏÖÔÚÏë°ÑÔÚDBGridÖвéѯµ½µÄÊý¾ÝiPlot×÷ͼ£¬ÇëÎÊÈçºÎʵÏÖÔÚDBGridÖеÄÊý¾Ý¶ÁÈ¡£¬¶Á³öµÄÊý¾ÝÊÇSTRINGÀàÐ͵ģ¬ÈçºÎÓÐЧµÄת±ä³ÉÊý¾Ý¿âÖÐËù´æ´¢µÄDOUBLEÀàÐ ......
ÔÚOracleÖУ¬ÎÒÏë²éϵͳʱ¼äÒ»ÌìµÄÊý¾Ý£¬Ê¹ÓÃÕâ¸öÓï¾ä
select * from tablename
where create_time>SYSDATE-1
and create_time <SYSDATE
ÎÒÏë²é×òÌì00£º00µ½½ñÌì00£º00µÄsqlÔõôд£¬
» ......
A±í B±í
WZID WZJG WZID CKID WZSL
ÏÖÔÚÒª²é¶ÔÓ¦µÄÿһ¸öCKIDϵÄ×ܵĽð¶î
¾ÍÊÇÏȲéÿ¸öWUIDÔÚB±íÀïµÄÊýÁ¿£¬È»ºóÓÃWZJG*sum(wzsl)£¬È»ºóÔÙ°´ÕÕÿ¸ ......
ÎÒµÄTblworkbill±íµÄÊý¾ÝÈçÏÂ:
id workbillno ..................
1 1
2 6
3 a1
4 c2
5 2
6 aa
7 ......