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

SQL Server ÈÕÆÚºÍʱ¼äº¯Êý


 
1¡¢³£ÓÃÈÕÆÚ·½·¨(ÏÂÃæµÄGetDate() = '2006-11-08 13:37:56.233')
(1)DATENAME ( datepart ,date )
   ·µ»Ø±íʾָ¶¨ÈÕÆÚµÄÖ¸¶¨ÈÕÆÚ²¿·ÖµÄ×Ö·û´®¡£DatepartÏê¼ûÏÂÃæµÄÁбí.
SELECT DateName(day,Getdate()) –·µ»Ø8
(2)DATEPART ( datepart , date )
    ·µ»Ø±íʾָ¶¨ÈÕÆÚµÄÖ¸¶¨ÈÕÆÚ²¿·ÖµÄÕûÊý¡£
SELECT DATEPART(year,Getdate()) –·µ»Ø2006
(3)DATEADD (datepart , number, date )
    ·µ»Ø¸øÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¸öʱ¼ä¼ä¸ôºóµÄÐÂdatetime Öµ¡£
SELECT DATEADD(week,1,GetDate()) --µ±Ç°ÈÕÆÚ¼ÓÒ»ÖܺóµÄÈÕÆÚ
(4)DATEDIFF ( datepart , startdate , enddate )
·µ»Ø¿çÁ½¸öÖ¸¶¨ÈÕÆÚµÄÈÕÆÚ±ß½çÊýºÍʱ¼ä±ß½çÊý¡£
SELECT DATEDIFF(month,'2006-10-11','2006-11-01') --·µ»Ø1
(5)DAY ( date )
·µ»ØÒ»¸öÕûÊý£¬±íʾָ¶¨ÈÕÆÚµÄÌìdatepart ²¿·Ö¡£
SELECT day(GetDate()) –·µ»Ø8
(6)GETDATE()
ÒÔdatetime ÖµµÄSQL Server 2005 ±ê×¼ÄÚ²¿¸ñʽ·µ»Øµ±Ç°ÏµÍ³ÈÕÆÚºÍʱ¼ä¡£
SELECT GetDate()   --·µ»Ø2006-11-08 13:37:56.233
(7)MONTH ( date )
·µ»Ø±íʾָ¶¨ÈÕÆÚµÄ“Ô”²¿·ÖµÄÕûÊý¡£
SELECT MONTH(GETDATE()) --·µ»Ø11
(8)YEAR ( date )
·µ»Ø±íʾָ¶¨ÈÕÆÚµÄ“Äꔲ¿·ÖµÄÕûÊý¡£
SELECT YEAR(GETDATE()) --·µ»Ø2006
2¡¢È¡Ìض¨ÈÕÆÚ
(1)»ñµÃµ±Ç°ÈÕÆÚÊÇÐÇÆÚ¼¸
SELECT DateName(weekday,Getdate()) --Wednesday
(2)¼ÆËãÄÄÒ»ÌìÊDZ¾ÖܵÄÐÇÆÚÒ»
SELECT DATEADD(week, DATEDIFF(week,'1900-01-01',getdate()), '1900-01-01')  --·µ»Ø2006-11-06 00:00:00.000
»ò
SELECT DATEADD(week, DATEDIFF(week,0,getdate()),0)     
(3)µ±Ç°¼¾¶ÈµÄµÚÒ»Ìì
SELECT DATEADD(quarter, DATEDIFF(quarter,0,getdate()), 0)—·µ»Ø2006-10-01 00:00:00.000
(4)ÈçºÎÈ¡µÃij¸öÔµÄÌìÊý
SELECT Day(dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,'2006-02-03')+1,0)))  —·µ»Ø28
(5)Ò»¸ö¼¾¶È¶àÉÙÌì
declare @m tinyint,@time smalldatetime
select @m=month(getdate())
select @m=case when @m between 1 and 3 then 1
                       when @m between 4 and 6 then 4
  


Ïà¹ØÎĵµ£º

´ÓSQLÊý¾Ý¿âÀïËæ»ú¶ÁȡһÌõ¼Ç¼



ÔõÑù´ÓÊý¾Ý¿âÀïËæ»ú¶ÁÈ¡
Ò»Ìõ¼Ç¼£¬
SELECT TOP 1 * from dbo.Customers ORDER BY  NEWID()
ÕâÑù£¬Èç¹ûÊÇËæ»ú10
Ìõ£¬100Ìõ¡£¡£¡£¡£
SELECT TOP 10 * from dbo.Customers ORDER BY  NEWID()
ºÜ¼òµ¥°É¡£
²»¹ýtopºóÃæÊý×ÖÔ½´ó£¬ÔËÐÐËÙ¶ÈÔ½Âý¡£²»ÍƼöÊý¾Ý×ÖÌ«´ó¡£
ÒÔºó´úÂëÔÚSQL2000 ......

JDBCµ÷ÓÃSql server 2005 ´æ´¢¹ý³Ì³öÏÖµÄÎÊÌâ

»·¾³£ºJDK1.5
Êý¾Ý¿â£ºSql server 2005 +sp2
JDBCÇý¶¯£ºsqljdbc.jar
²âÊÔÀà´úÂëÈçÏ£º
import java.sql.*;
public class test {
 /**
  * @param args
  * @throws SQLException
  * @throws ClassNotFoundException
  */
 public static void main(String[] args) throws SQL ......

ÓÃSQLÓï¾äÆ´½ÓÊý¾Ý¿â±íÖÐÒ»ÁеÄÊý¾Ý

×î½üÔÚÒ»¸öÏîÄ¿ÖÐÓöµ½ÐèÒªÔÚÊý¾Ý²ã¾ÍÆ´½Ó±íÖÐÒ»ÁÐÊý¾ÝµÄÎÊÌâ¡£
ÀýÈ磬test±íÖÐÓиö×Ö¶Ît,tÁÐÖеÄ4ÐÐÊý¾ÝΪ1,2,3,4 £¬ÒªÆ´½Ó³É1+2+3+4£¬×ÁÄ¥ÁËÒ»Õ󣬱¾À´ÏëÓÃÓα꣬µ«ÊÇЧÂÊ¡£¡£ºóÀ´ÕÒµ½Ò»¶ÎSQL£¬¿ÉÒԺܷ½±ãµØÆ´½Ó¡£
DECLARE @STR VARCHAR(8000) ----¶¨Òå²éѯ×Ö·û´®
SELECT @STR=ISNULL(@STR+'+','')+t from (SELECT DIST ......

²é¿´SQL ServerÈÕÖ¾µÄ·½·¨

ת×Ôhttp://blog.csdn.net/ziren235/archive/2007/07/03/1676347.aspx
ÔÚSQL Server2000ÖУ¬Ò»¸öÊý¾Ý¿âµÄÈÕÖ¾ÊÇÒÔ*.ldf Îļþ´æ·Å,ÇëÎÊÎÒÏë²é¿´Ä³Ò»¸öÊý¾Ý¿âµÄÈÕÖ¾,¸ÃÈçºÎ²Ù×÷.
·½·¨1¡¢
DBCC LOG('DatabaseName',2)
·½·¨2:
select * from ::fn_dblog(default,default)
·½·¨3
ÓÃLog Explorer ......

[SQL Server] ÈÕÖ¾¹ÜÀí(´ýÐø)

 --±¸·ÝÊÂÎñÈÕÖ¾ (×ÔÉÏÒ»´Î±¸·ÝÒÔÀ´£¬ÖÁµ±Ç°µÄÒÑÍê³ÉµÄÊÂÎñµÄÈÕÖ¾)
backup log MyDBName to disk='F:\dbbak\GamePoint\MyDBName_log_2010052709.bak';
 
--½Ø¶ÏÈÕÖ¾(½Ø¶Ïµôµ±Ç°µÄÒÑÍê³ÉµÄÊÂÎñµÄÈÕÖ¾), SQL Server 2005, 2008ûÓÐÕâ¸öÑ¡Ïî.
backup log MyDBName with no_Log;
 
--ÊÕËõÈÕÖ¾(ÖÁ1M,µ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ