sqlÌØÊâÓï·¨
¸´ÖƱíµÄ½á¹¹
select * into newtable from oldtable where 1<>1
¸´ÖƱí´ï¶îÄÚÈÝ
insert into new table select *(ÁÐÃû) from oldtable
datediffº¯ÊýÓ÷¨
×÷ÓÃ
·µ»ØÁ½¸öÈÕÆÚÖ®¼äµÄ¼ä¸ô¡£
Óï·¨
DATEDIFF ( date-part, date-expression1, date-expression2 )
date-part :
year | quarter | month | week | day | hour | minute | second | millisecond
²ÎÊý
date-part Ö¸¶¨Òª¼ÆËãÆä¼ä¸ôµÄÈÕÆÚ²¿·Ö¡£
date-expression1 ijһ¼ä¸ôµÄÆðʼÈÕÆÚ¡£´Ó date-expression2 ÖмõÈ¥¸ÃÖµ£¬·µ»ØÁ½¸ö²ÎÊýÖ®¼ä date-parts µÄÊýÖµ¡£
date-expression2 ijһ¼ä¸ôµÄ½áÊøÈÕÆÚ¡£´Ó¸ÃÖµÖмõÈ¥ Date-expression1£¬·µ»ØÁ½¸ö²ÎÊýÖ®¼ä date-parts µÄÊýÖµ¡£
case when Óï·¨Ò²³£ÓÃ
Ïà¹ØÎĵµ£º
bcpÊÇSQL ServerÖиºÔðµ¼Èëµ¼³öÊý¾ÝµÄÒ»¸öÃüÁîÐй¤¾ß£¬ËüÊÇ»ùÓÚDB-LibraryµÄ£¬²¢ÇÒÄÜÒÔ²¢Ðеķ½Ê½¸ßЧµØµ¼Èëµ¼³ö´óÅúÁ¿µÄÊý¾Ý¡£bcp¿ÉÒÔ½«Êý¾Ý¿âµÄ±í»òÊÓͼֱ½Óµ¼³ö£¬Ò²ÄÜͨ¹ýSELECT fromÓï¾ä¶Ô±í»òÊÓͼ½øÐйýÂ˺󵼳ö¡£ÔÚµ¼Èëµ¼³öÊý¾Ýʱ£¬¿ÉÒÔʹÓÃĬÈÏÖµ»òÊÇʹÓÃÒ»¸ö¸ñʽÎļþ½«ÎļþÖеÄÊý¾Ýµ¼Èëµ½Êý¾Ý¿â»ò½«Êý¾Ý¿âÖеÄÊý¾Ýµ ......
ת×Ô£ºhttp://news.newhua.com/news1/program_database/2008/530/0853093226E2KJ93C02415FEB1CD9A5HCKA821556279EEKJ7728GI5.html
ÊÂÎñÈÕÖ¾ÎļþTransaction Log FileÊÇÓÃÀ´¼Ç¼Êý¾Ý¿â¸üÐÂÇé¿öµÄÎļþ£¬À©Õ¹ÃûΪldf¡£
ÔÚ SQL Server 7.0 ºÍ SQL Server 2000 ÖУ¬Èç¹ûÉèÖÃÁË×Ô¶¯Ôö³¤¹¦ÄÜ£¬ÊÂÎñÈÕÖ¾Îļþ½«»á×Ô¶¯À©Õ¹¡£
Ò»° ......
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE data ......
1¡¢SQLÊÇÒ»ÖÖ˵Ã÷ÐÔÓïÑÔ£¬²»Êǹý³Ì»¯ÓïÑÔ¡£ÀàËÆ“¼ìË÷->¼ì²é->²åÈë->¸üДµÄ¹ý³Ì»¯²½ÖèµÄ˳ÐòÊÇûÓÐÒâÒåµÄ¡£Ó¦¸ÃÒÔÐм¯µÄ·½Ê½Ë¼¿¼£¬ÒÔÃèÊöÒ»¸öÂß¼µÄÓïÑÔ·½Ê½Ë¼¿¼¡£
2¡¢ÔÚÉè¼ÆÊý¾Ý¿â±í×Ö¶Îʱ£¬Ò»¸öÐÐÃèÊöÓ¦¸Ã°üº¬Ò»¸öÊÂʵ£¬¶øÇÒÊÇÈ«²¿ÊÂʵ¡£ÀýÈ翼ÇÚ¿¨µÄÉè¼Æ£¬
²»ÒªÉè¼ÆΪ£º[ userId, puchTime, even ......
--> Title : ijÍâÆóSQL ServerÃæ試題
--> Author : wufeng4552
--> Date : 2010-1-15
Question 1£ºCan you use a batch SQL or store procedure to calculating the Number of Days in a Month
Answer 1£ºÕÒ³öµ±ÔµÄÌìÊý
select datepart(dd,dateadd(dd,-1,dateadd(mm,1,cast( ......