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
Ïà¹ØÎĵµ£º
StringBuilder Asql = new StringBuilder();
Asql.Append(" select '' as 'ÐòºÅ', T_Station.µµ°¸ºÅ,T_Station.StationName as '̨վÃû' , ");
Asql.Append(" ÇøÕ¾ºÅ.ÇøÕ ......
¶ÔÏóÃüÃûµÄÔ¼¶¨£ºÊý¾Ý¿âÃû.ËùÓÐÕßÃû.¶ÔÏóÃû
ǰÁ½Õß¿ÉÊ¡ÂÔ£¬Ä¬ÈÏÖµÊý¾Ý¿âÊǵ±Ç°Êý¾Ý¿â£¬ËùÓÐÕßÊÇdbo
±ðÃû£ºÊý¾Ý¿âÃû³Æ as Êý¾Ý¿â±íÃû Ö÷ÒªÊÇÔö¼ÓselectÓï¾äµÄ¿É¶ÁÐÔ£¬Èç¹ûÒѾΪÊý¾Ý±íÖÆ¶¨Á˱ðÃû£¬Ôò
ÔÚÏàÓ¦µÄSQLÓï¾äÖУ¬¶Ô¸ÃÊý¾Ý±íµÄËùÓÐÏÔʾÒýÓö¼ÒªÊ¹ÓñðÃû£¬¶ø²»ÄÜʹÓÃÊý¾Ý±íÃû¡£
selectÓï¾äÊÇÊý¾Ý¼ìË÷ÖÐ×îÆµ·±µÄ»î¶ ......
µ¼³ö£º
Ö±½Ó´ò¿ª²éѯ·ÖÎöÆ÷²éѯҪµ¼³ö±íµÄÐÅÏ¢£¨select * from ±í£©£¬µÃµ½µÄ½á¹ûȫѡ£¬ÓÒ¼üÁí´æÎª xxx.csvÎļþ £¨µÃµ½¸Ã±íµÄËùÓÐÐÅÏ¢£¬CSVÎļþ¸ñʽ£©
µ¼È룺
Ê×ÏÈͨ¹ýsql server µÄÆóÒµ¹ÜÀíÆ÷Éú³ÉÒªµ¼³ö±íµÄ SQL½Å±¾£¬²½Ö裺Ҫµ¼³ö±í——ËùÓÐÈÎÎñ£¨ÓÒ¼ü£©——Éú³ÉSQL½Å±¾
µÃµ½¸Ã±íµÄ ......
ÔÎijö´¦£ºhttp://blog.csdn.net/zk911/archive/2005/11/23/535432.aspx
×÷Õߣºzk911
¿´ÍêÕâÆªÎÄÕµĵÚÒ»¸Ð¾õÊÇ£¬ËäÈ»¶ÔÓÚÈÕÆÚÀàÐÍÊý¾ÝʹÓõúÜËã˳Àû£¬²»¹ý×÷Õß Ìáµ½µÄһЩ¶«Î÷»¹Õæ²»ÖªµÀ¡£ÓÐʱºòÔÚÓ¦ÓÃÉÏ£¬²»¾õµÃ±ÈÀÏÍâ²îµ½ÄÇÀïÈ¥¡£µ«ÊÇ£¬ ÀÏÍâµÄÒ»¸öÓÅÁ¼Ï°¹ßϸ¿Û¸ÅÄî²¢½øÐÐʵ֤¼ìÑ飻¶øÎÒÃǵÄϰ¹ßÊǸÅÄîÊǸÅÄӦÓÃ Ê ......
SELECT ±íÃû = CASE a.colorder WHEN 1 THEN c.name ELSE '' END,
Ðò = a.colorder,
×Ö¶ÎÃû = a.name,
±êʶ = CASE COLUMNPROPERTY(a.id,a.name, ......