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

SQL ²é¿´±¾ÖܵÄÐÇÆÚÒ»ºÍÐÇÆÚÌì

--SQL ²é¿´±¾ÖܵÄÐÇÆÚÒ»ºÍÐÇÆÚÌì
/*
ϵͳµÄʱ¼äĬÈϰÑÐÇÆÚÌì×÷Ϊһ¸öÐÇÆÚµÄµÚÒ»Ì죬µ«ÊÇÎÒÃÇÖйúϰ¹ß°ÑÐÇÆÚÒ»×÷Ϊһ¸öÐÇÆÚµÄµÚÒ»Ì죬Òò´ËÈç¹ûµ±ÌìÊÇÐÇÆÚÌìʱÐèÒªÅжÏÒ»ÏÂ
*/
DECLARE @MondayTime varchar(10)
DECLARE @SundayTime varchar(10)
IF(datepart(weekday,getdate())-2 < 0)
BEGIN
 SET @MondayTime = convert(varchar(10),dateadd(dd,-1,getdate())-(datepart(weekday,dateadd(dd,-1,getdate()))-2),120)
 SET @SundayTime = convert(varchar(10),dateadd(dd,-1,getdate())+(8-datepart(weekday,dateadd(dd,-1,getdate()))),120)
END
ELSE
 BEGIN
  SET @MondayTime =convert(varchar(10),getdate()-(datepart(weekday,getdate())-2),120)
  SET @SundayTime =convert(varchar(10),getdate()+(8-datepart(weekday,getdate())),120)
 END
 SELECT @MondayTime as 'µÚÒ»Ìì(ÖÜÒ»)', @SundayTime as '×îºóÒ»Ìì(ÖÜÈÕ)'
 
--Ò²¿ÉÒÔÉèÖÃÿÖܵĵÚÒ»Ìì
ÉèÖÃÐÇÆÚһΪһÖܵĵÚÒ»Ìì
SET DATEFIRST ÉèÖÃÒ»ÖܵĵÚÒ»ÌìÊÇÐÇÆÚ¼¸£¬¸ÃÉèÖöÔËùÓÐÓû§¾ùÓÐЧ£¬³ý·ÇÔÙ´ÎÐ޸쬷ñÔò¸ÃÉèÖý«Ò»Ö±±£Áô¡£
SET DATEFIRSTµÄ¾ßÌåÓï·¨ÈçÏ£º
SET DATEFIRST { number | @number_var }
ÆäÖвÎÊýnumber | @number_varÊÇÒ»¸öÕûÊý£¬±íʾһÖܵĵÚÒ»Ìì¡£ÔÊÐíµÄÖµÊÇ1¡«7£¬1±íʾһÖܵĵÚÒ»ÌìÊÇÐÇÆÚÒ»£¬7±íʾһÖܵĵÚÒ»Ìì¶ÔӦΪÐÇÆÚÈÕ¡£numberµÄĬÈÏÖµÊÇ7£¨¼´Ò»ÖܵĵÚÒ»ÌìΪÐÇÆÚÈÕ£©¡£¿ÉÒÔͨ¹ý²éѯϵͳ±äÁ¿@@DATEFIRST»ñÈ¡µ±Ç°µÄSET DATEFIRSTÉèÖÃÖµ¡£
DATENAME(dw,date)¼°DATEPART(dw,date)µÄ½á¹û»áÊܵ½SET DATEFIRSTÉèÖÃÖµµÄÓ°Ïì¡£
SET DATEFIRST 1
--Õâʱ²éÕÒ±¾ÖܵÄÊý¾Ý¾Í·½±ã¶àÁË
SELECT * from T_news WHERE (DATEPART(wk, addtime) = DATEPART(wk, GETDATE())) AND (DATEPART(yy, addtime) = DATEPART(yy, GETDATE()))
ÁíÍ⣺
Ò»Ìì "select * from T_news where datediff(day,addtime,getdate())=0";
ÈýÌì "select * from T_news where datediff(day,addtime,getdate())<= 2 and datediff(day,addtime,getdate())>= 0";
Ò»ÔÂ "SELECT * from T_news WHERE (DATEPART(yy, addtime) = DATEPART(yy, GETDATE())) AND (DATEPART(mm, addtime) = DATEPART(mm, GETDATE()))";
Ò»¼¾¶È "select * from t_news where DATEPART(qq, addtime) = DATEPART(qq, GETDATE()) and DATEPART(yy, a


Ïà¹ØÎĵµ£º

SQL ÖÐhaving ºÍwhereµÄÇø±ð

group by
 
    ÔÚselect Óï¾äÖпÉÒÔʹÓÃgroup by ×Ӿ佫Ðл®·Ö³É½ÏСµÄ×飬Ȼºó£¬Ê¹ÓþÛ×麯Êý·µ»ØÃ¿Ò»¸ö×éµÄ»ã×ÜÐÅÏ¢£¬ÁíÍ⣬¿ÉÒÔʹÓÃhaving×Ó¾äÏÞÖÆ·µ»ØµÄ½á¹û¼¯¡£group by ×Ó¾ä¿ÉÒÔ½«²éѯ½á¹û·Ö×飬²¢·µ»ØÐеĻã×ÜÐÅÏ¢Oracle °´ÕÕgroup by  ......

SQLÓïÑÔ»ù´¡£¨1£©

¶ÔÏóÃüÃûµÄÔ¼¶¨£ºÊý¾Ý¿âÃû.ËùÓÐÕßÃû.¶ÔÏóÃû
ǰÁ½Õß¿ÉÊ¡ÂÔ£¬Ä¬ÈÏÖµÊý¾Ý¿âÊǵ±Ç°Êý¾Ý¿â£¬ËùÓÐÕßÊÇdbo
±ðÃû£ºÊý¾Ý¿âÃû³Æ as Êý¾Ý¿â±íÃû Ö÷ÒªÊÇÔö¼ÓselectÓï¾äµÄ¿É¶ÁÐÔ£¬Èç¹ûÒѾ­ÎªÊý¾Ý±íÖÆ¶¨Á˱ðÃû£¬Ôò
ÔÚÏàÓ¦µÄSQLÓï¾äÖУ¬¶Ô¸ÃÊý¾Ý±íµÄËùÓÐÏÔʾÒýÓö¼ÒªÊ¹ÓñðÃû£¬¶ø²»ÄÜʹÓÃÊý¾Ý±íÃû¡£
selectÓï¾äÊÇÊý¾Ý¼ìË÷ÖÐ×îÆµ·±µÄ»î¶ ......

sql serverÖеÄconvertÈÕÆÚ¸ñʽ»¯´óÈ«

CONVERT
½«Ä³ÖÖÊý¾ÝÀàÐ͵ıí´ïʽÏÔʽת»»ÎªÁíÒ»ÖÖÊý¾ÝÀàÐÍ¡£ÓÉÓÚijЩÐèÇó¾­³£Óõ½È¡ÈÕÆÚ¸ñʽµÄ²»Í¬.ÏÖÒÔÏ¿ÉÔÚ
SQL ServerÖС¡½«ÈÕÆÚ¸ñʽ»¯.
SQL Server Ö§³ÖʹÓÿÆÍþÌØËã·¨µÄ°¢À­²®ÑùʽÖеÄÊý¾Ý¸ñʽ¡£
ÔÚ±íÖУ¬×ó²àµÄÁ½Áбíʾ½« datetime »ò smalldatetime ת»»Îª×Ö·ûÊý¾ÝµÄ style Öµ¡£¸ø style Öµ¼Ó 100£¬¿É»ñµÃ°üÀ¨Ê ......

¶¯Ì¬Ö´ÐÐSqlÓï¾äÓëÁÙʱ±íµÄÎÊÌâ(¶ÔÏóÃûÎÞЧ)

exec('selectIDENTITY(int,1,1)  as ID,fnum,into  #yuecu  from  store_store where  '+@Parameter)  
select  XX,XX1,XX2  from  #yuecu 
ÕâÑù´´½¨Ò»¸öÁÙʱ±íÒÔºóÎÒÔÙÏë´ÓÁÙʱ±íÖÐÈ¡Êý¾ÝÌáʾ¶ÔÏóÃû#yuecu&n ......

ʲôÊÇ SQL Developer£¿

Oracle SQL Developer ÊÇÒ»¸öÃâ·ÑµÄͼÐλ¯Êý¾Ý¿â¿ª·¢¹¤¾ß¡£Ê¹Óà SQL Developer£¬Äú¿ÉÒÔä¯ÀÀÊý¾Ý¿â¶ÔÏó¡¢ÔËÐÐ SQL Óï¾äºÍ SQL ½Å±¾£¬²¢ÇÒ»¹¿ÉÒԱ༭ºÍµ÷ÊÔ PL/SQL Óï¾ä¡£Äú»¹¿ÉÒÔÔËÐÐËùÌṩµÄÈκÎÊýÁ¿µÄ±¨±í£¬ÒÔ¼°´´½¨ºÍ±£´æÄú×Ô¼ºµÄ±¨±í¡£SQL Developer ¿ÉÒÔÌá¸ß¹¤×÷ЧÂʲ¢¼ò»¯Êý¾Ý¿â¿ª·¢ÈÎÎñ¡£
SQL Developer ¿ÉÒÔÁ¬½Óµ½È ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ