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

Çë½ÌSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

Card_dateTime CardNo Mc_ID
2010-05-28 16:15:00 0002001001 08
2010-05-28 16:16:00 0002001001 08
2010-05-28 16:17:00 0002001001 08
2010-05-28 16:17:00 0002001014 08
2010-05-28 16:19:00 0002001021 08
2010-05-28 16:20:00 0002001021 08
2010-05-28 16:20:00 0002001021 08
2010-05-28 16:22:00 0002001021 08
2010-05-28 16:22:00 0002001021 08
2010-05-28 16:24:00 0002002003 08
2010-05-28 16:27:00 0002002003 08
2010-05-28 17:04:00 0002002005 08
2010-05-28 17:04:00 0002002005 08
2010-05-28 19:07:00 0002002005 08
2010-05-28 20:13:00 0002002006 08
2010-05-28 20:27:00 0002002018 08
2010-05-28 20:28:00 0002002018 08
2010-05-28 20:29:00 0002002018 08
2010-05-28 20:29:00 0002002024 08
2010-05-28 20:29:00 0002002024 08
2010-05-28 20:29:00 0002002024 08
2010-05-28 20:30:00 0002002024 08
2010-05-28 20:30:00 0002002024 08
2010-05-28 20:31:00 0002002033 08
2010-05-28 20:31:00 0002002033 08
2010-05-28 20:32:00 0002002038 08
2010-05-28 20:32:00 0002002038 08
2010-05-28 20:32:00 0002002041 08
2010-05-28 20:32:00 0002002041 08
2010-05-28 20:33:00 0002002041 08
2010-05-28 20:33:00 0002002041 08

Çë½ÌÒ»ÌõSQLÓï¾ä£¬ÒªÇó²éѯ³öËùÓмǼÌÞ³ý3·ÖÖÓÄÚµÄË¢¿¨¼Ç¼£¨ÒÔCard_dateTime×îСΪ׼£©£¬Ö»Êä³öÒ»´Î£¬ÀýÈç
2010-05-28 16:15:00 0002001001 08
2010-05-28 16:16:00 0002001001 08
2010-05-28 16:17:00 0002001001 08

Ö»Êä³ö 2010-05-28 16:1


Ïà¹ØÎÊ´ð£º

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

Ò»Ìõ SQL - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÐÕâÑùÒ»ÌõSQL
 Select Get_Costtaxrate(col1), Get_Tcostvalue(col1) from a
 
ÆäÖÐGet_Costtaxrate¡¢Get_Tcostvalue¶¼ÊǺ¯Êý£¬ÕâÁ½¸öº¯ÊýÀïÃæ¶¼ÊDzéÕÒÒ»¸ö´ó±í£¬Get_Tcostvalue»¹ÐèÒªµ÷ÓÃGet_C ......

¹ØÓÚSqlµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡


¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡

Ö±½ÓÖ´ÐоÍÐÐÁË

exec ......

¹ØÓÚSQLÓï¾äORµÄÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
......

ASPÒ³ÃæÎÞ·¨´ò¿ªÇóÖú£¡ - MS-SQL Server / »ù´¡Àà

¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ