sqlÓï¾ä»ñÈ¡±¾ÖÜ¡¢ÉÏÒ»ÖÜ¡¢±¾ÔÂÊý¾Ý
±¾ÖÜ
select * from tb where datediff(week , ʱ¼ä×Ö¶Î ,getdate()) = 0
ÉÏÖÜ
select * from tb where datediff(week , ʱ¼ä×Ö¶Î ,getdate()) = 1
ÏÂÖÜ
select * from tb where datediff(week , ʱ¼ä×Ö¶Î ,getdate()) = -1
----------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------
--ÉÏÔÂ
Select * from TableName Where DateDiff(mm, DateTimCol, GetDate()) = 1
--±¾ÔÂ
Select * from TableName Where DateDiff(mm, DateTimCol, GetDate()) = 0
--ÏÂÔÂ
Select * from TableName Where DateDiff(mm, GetDate(), DateTimCol ) = 1
×òÌ죺dateadd(day,-1,getdate())
Ã÷Ì죺dateadd(day,1,getdate())
ÉÏÔ£ºmonth(dateadd(month, -1, getdate()))
±¾Ô£ºmonth(getdate())
ÏÂÔ£ºmonth(dateadd(month, 1, getdate()))
---------------------------------------------------------------------------------
--×òÌì¡¡
Select * from TableName Where DateDiff(dd, DateTimCol, GetDate()) = 1
--Ã÷Ìì
Select * from TableName Where DateDiff(dd, GetDate(), DateTimCol) = 1
--×î½üÆßÌì
Select * from TableName Where DateDiff(dd, DateTimCol, GetDate()) <= 7
--ËæºóÆßÌì
Ïà¹ØÎĵµ£º
Êý¾Ý¿âÃæÊÔ³£ÓòâÊÔÌâ(SQL Server)
ÌâÄ¿1
¡¡¡¡ÎÊÌâÃèÊö:
¡¡¡¡Îª¹ÜÀí¸ÚλҵÎñÅàѵÐÅÏ¢£¬½¨Á¢3¸ö±í:
¡¡¡¡S (S#,SN,SD,SA) S#,SN,SD,SA ·Ö±ð´ú±íѧºÅ¡¢Ñ§Ô±ÐÕÃû¡¢ËùÊôµ¥Î»¡¢Ñ§Ô±ÄêÁä
¡¡¡¡C (C#,CN ) C#,CN ·Ö±ð´ú±í¿Î³Ì±àºÅ¡¢¿Î³ÌÃû³Æ
¡¡¡¡SC ( S#,C#,G ) S#,C#,G ·Ö±ð´ú±íѧºÅ¡¢ËùÑ¡Ð޵Ŀγ̱àºÅ¡¢Ñ§Ï°³É¼¨
¡¡¡¡1. Ê¹Ó ......
Ê×ÏȵÃÏÂÔØÇý¶¯³ÌÐòµ½Î¢ÈíÍøÕ¾ÏÂÔØMicrosoft SQL Server 2005 JDBC Driver 1.2
½âѹMicrosoft SQL Server 2005 jdbc driver1.2.exe£¬°Ñsqljdbc_1.1¸´ÖƵ½%ProgramFiles%£¨Èç¹ûϵͳÔÚCÅÌÔòΪC:\Program Files£©¡£
ÉèÖÃ Classpath
JDBC Çý¶¯³ÌÐò²¢Î´°üº¬ÔÚ Java SDK ÖС£Òò´Ë£¬Èç¹ûҪʹÓøÃÇý¶¯³ÌÐò£¬±ØÐ뽫 classpath ......
1¡¢°²×°Sql Server2005 Mobile Edition£»
2¡¢¾ßÌåÔÚ´´½¨Ò»¸ö¹¤³ÌÒÔºó£¬ÏëʹÓÃSqlServerCe±ØÐëÔÚ×Ô¼º¹¤³ÌµÄÒýÓÃÀïÃæÌí¼ÓÒ»¸ödll²ÅÐУ»
ÆäĿ¼ÔÚ£ºC:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\System.Data.SqlServerCe.dll
Ìí¼ÓÁËÒÔºó¾Í¿ÉÒÔʹÓÃMobileµÄһЩÊý¾Ý¿â²Ù×÷µÄÀà¿âÁË¡£ ......
Ò»¡¢Ö÷ÒªÊÇÐèÒª¸üÐÂmssqlServer µÄʱºòÐèÒª½øÐÐһЩÊÇ·ñ´æÔÚµÄÅжϣ¬ÔÚmssql2000 ºÍ 2005 ÉϲâÊÔûÓÐŶÎÊÌâ
--//ÅжÏÊDZíTable_UserInfoÀïÊÇ·ñÓÐ×Ö¶Î
if not exists(select * from syscolumns where id=object_id('Table_UserInfo') and name='Tel') begin
ALTER table Table_UserInfo add Tel varchar(200)--Ôö¼Ó×Ö¶Î
......