sql±à¼¹¤¾ß
´ó¼Ò¶¼ÓÃʲôsqlÓï¾ä±à¼¹¤¾ß£¡»¹ÊÇÖ»½ÓÓòéѯ·ÖÎöÆ÷£¿ÍøÉÏÕÒÁËЩPL/SQL developerÕâºÃÏñÊÇÁ¬OraclerµÄ
ÎÒÖ»ÏëÒª¸öSQl±à¼¹¤¾ß
SSMS.
²éѯ·ÖÎöÆ÷×ã¹»ÁË
±¾ÈË×î½üÔÚѧϰsql
µ«Ã¿´Î¶¼ÒªÍù²éѯ·ÖÎöÆ÷ÉÏÌù
¶øÇÒ×ÖÌåºÜС
²éѯ·ÖÎöÆ÷
²Î¿¼´ËÌùhttp://topic.csdn.net/u/20091007/20/e4b03891-12ea-4ffb-bbbd-d65497d5fc85.html?55649
ÆäʵÈç¹ûÄã×ö.netµÄ»°£¬¿ÉÒÔÓÃһϣº¶¯Èí.net´úÂëÉú³ÉÆ÷£¬ÀïÃæ¿ÉÒÔÁ¬¸÷ÖÖÊý¾Ý¿â£¬×öÊý¾Ý¿âºÜ·½±ã¡£²»×ö.netÆäʵҲ¿ÉÒÔÓ㬿ÉÒÔµ±×ö²éѯ·ÖÎöÆ÷Ó㬲»¹ý±ÈÄǶ«Î÷»¹ÊµÓÃЩ£¬¹¦Äܸü¶à£¬¸üÇ¿¡£¡£¡£
Ïà¹ØÎÊ´ð£º
ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç "2009-01","8949-232"
½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......
3.ѧÉú±í£¬Ñ¡¿Î±í¡£¿Î³Ì±í¡£Èý¸ö±í£¬ÕÒ³öÑ¡ËùÓпγ̵ÄѧÉú¡£
4.ѧÉú±í£¬Ñ¡¿Î±í¡£¿Î³Ì±í¡£Èý¸ö±í£¬ÕÒ³öÑ¡ÁË5ÃÅÒÔÉϿγ̵ÄѧÉú¡£
5.ѧÉú±í£¬³É¼¨±í¡£¿Î³Ì±í¡£Èý¸ö±í£¬ÕÒ³öËùÓпγ̵ķÖÊýÔÚ80·ÖÒÔÉϵÄѧÉú¡£
......
SELECT Count(*) from In_fo WHERE Reader_Time between #" + time1 + "# AND #" + time2 + "# and id=" + userid + ";
ÉÏÃæÊÇÎÒдµÄsqlÓï¾ä Reader_TimeÊÇʱ¼äÀàÐÍ idΪÊý×Ö ......
×îÏÈϵͳװÓÐsql2000£¬ÀïÃæÒ²ÔËÐÐÁ˺öàÍøÕ¾Êý¾Ý¿âÓ¦ÓóÌÐò£¬ÏÖÔÚÓиöÍøÕ¾ÐèÒªÅÜÔÚsql server2005ƽ̨ÉÏ£¬ÇëÎÊÎÒ¿ÉÒÔÖ±½ÓÔÚÕâ¸ö°²×°ÓÐsql server2000µÄ·þÎñÆ÷ÉÏÖ±½Ó°²×°sql server2005Â𣿻᲻»áÁ½¸ö°æ±¾µÄ·¢Éú¼æÈÝÐ ......