Çóһʱ¼ä±È½ÏµÄSQL Ö¸Áî - MS-SQL Server / »ù´¡Àà
±íÊý¾Ý
COL1 COL2 COL2 COL4 COL5
----------------------------------------------------------------------------------------------
2010-05-05 00:00:00.000 1000011 Õźì 1900-01-01 07:22:57.000 1900-01-01 19:31:46.000
2010-05-06 00:00:00.000 1000011 Õźì 1900-01-01 07:21:17.000 1900-01-01 19:30:30.000
2010-05-07 00:00:00.000 1000011 Õźì 1900-01-01 07:22:50.000 1900-01-01 19:30:46.000
2010-05-08 00:00:00.000 1000011 Õźì 1900-01-01 07:23:17.000 1900-01-01 19:30:50.000
2010-05-05 00:00:00.000 1061392 Áõ»Ô 1900-01-01 07:26:59.000 1900-01-01 17:33:52.000
2010-05-06 00:00:00.000 1061487 Áõ»Ô 1900-01-01 07:20:05.000 1900-01-01 16:32:26.000
2010-05-07 00:00:00.000 1061392 Áõ»Ô 1900-01-01 07:26:59.000 1900-01-01 17:30:52.000
2010-05-08 00:00:00.000 1061487 Áõ»Ô 1900-01-01 07:20:05.000 1900-01-01 17:32:26.000
ÐèÇó˵Ã÷
±íÖÐÓÐÈÕÆÚ£¬¹¤ºÅ£¬ÉÏ°àµÚÒ»´Î¿¼ÇÚÓë×îºóÒ»´Î¿¼ÇÚ£¬Í¬Ò»ÌìÖ»ÓÐÒ»Ìõ¿¼ÇڼǼ£¬ÇóÁ½Ìì֮ǰµÄ´ò¿¨Ê±¼ä²îµÄСʱÊý
£¨Í¬Ò»¹¤ºÅ£¬Ç°Ò»ÌìµÄ×îºóÒ»´Î¿¼ÇÚͬ´ÎÈյĵÚÒ»´Î¿¼ÇÚʱ¼ä²î£©¡£
ÓÃdiffº¯Êý convertת³É×Ö·û´®ÐÍ
ÔΣ¬Â¥ÉϵĻì·ÖÁ˲»ÊÇÕâÑù»ìµÄ
datediff±¾À´¾ÍÊÇ
û¿´Ã÷°×ÐèÇó
http://topic.csdn.net/u/20100519/06/1a026276-9b20-43ac-91fd-1f5a18b9cb74.html?55580
²Î¿¼ÕâÌù
SQL code:
create table tb(COL1
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄÇ°2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
Çë½Ì¸ßÊÖ£º
ÒÔÏÂÊÇÊý¾Ý¿âÖеÄÈýÌõ¼Ç¼£¬Ó¢ÎÄΪ×Ö¶ÎÃû³Æ
id planname TaskBeginTime Status
329 2010Äê03 ......
½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡
¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡
Ö±½ÓÖ´ÐоÍÐÐÁË
exec ......