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

SQLÈëÃż¶ÎÊÌâ¡£ - MS-SQL Server / »ù´¡Àà

ΪʲôweekÊǹؼü×Ö£¬¶ødayÊÇϵͳº¯Êý¡£
ÎÊMS£¬


Õâ
ÎÊ΢Èí

ÕâÄãÒ²¹ÜµÃÁË?

ÒýÓÃ
ÆäʵdayÒ²¿ÉÒÔ×ö¹Ø¼ü×ÖÂֻÊÇûÓÐweek()Õâ¸öº¯Êý¶øÒÑ£¬ÈçÔÚ£ºdatediff(day,date1,date2)ÖÐday¾ÍÊǹؼü×ÖŶ


»Ø´ðµÃºÜºÃ

day¼ÈÊǺ¯ÊýÒ²Êǹؼü×Ö

ÎÒÀ´¿´¿´µÄ!

ÎÊËû°ÖÂè

¿ÉÒÔDATAPART(WEEK, GETDATE())


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

SQLÓï¾äÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

Çë½Ì¸ßÊÖ£º
 ÒÔÏÂÊÇÊý¾Ý¿âÖеÄÈýÌõ¼Ç¼£¬Ó¢ÎÄΪ×Ö¶ÎÃû³Æ  
  id planname TaskBeginTime Status
329 2010Äê03 ......

ÇóÒ»ÌõSQLÓï¾ä - MS-SQL Server / Ó¦ÓÃʵÀý

Ô­SQLÓï¾äSQL code:

SELECT t6.FName '²Ù×÷¹¤',t1.FDate 'ÈÕÆÚ',t5.FName 'ÖÆµ¥ÈË',t3.FName 'É豸',t4.FName '°àÖÆ',
t7.FBillNo '¹¤ÒÕÖ¸Áîµ¥ºÅ',t8.FName '¸Úλ',t2. ......

SQL·ÖÒ³ÓëOracle·ÖÒ³µÄÒÉÎÊ£¿ - Java / Web ¿ª·¢

ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ