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

SQL³£ÓÃÈÕÆÚʱ¼ä´¦Àíº¯Êý

×î½üÔÚÔÚÒ»µçÁ¦ÏµÍ³£¬ÀïÃæÓõ½±¨±í£¬¾­³£ÐèÒª¶ÔSQLÈÕÆÚ½øÐвÙ×÷¡£ÏÖÔÚ½«Ò»Ð©³£ÓõÄSQLÈÕÆÚ²Ù×÷º¯Êý¼ÇÏÂ
/**//**//**//* datepart()º¯ÊýµÄʹÓà                     ¡¡¡¡
* datepart()º¯Êý¿ÉÒÔ·½±ãµÄÈ¡µ½Ê±ÆÚÖеĸ÷¸ö²¿·Ö
*ÈçÈÕÆÚ£º2006-07--02 18£º15£º36.513
* yy:È¡Äê       ¡¡¡¡2006
* mm:ȡԠ      ¡¡¡¡7
* dd:È¡ÔÂÖеÄÌì ¡¡¡¡2
* dy:È¡ÄêÖеÄÌì ¡¡¡¡183
* wk:È¡ÄêÖеÄÖÜ ¡¡¡¡27
* dw:È¡ÖÜÖеÄÌì ¡¡¡¡1
* qq:È¡ÄêÖеļ¾¶È   3
* hh:ȡСʱ    ¡¡¡¡18
* mi:È¡·ÖÖÓ    ¡¡¡¡15
* ss:È¡Ãë      ¡¡¡¡36
* ÒÔϼòµ¥µÄÓï¾ä¿ÉÒÔÑÝʾËùÈ¡µ½µÄ½á¹û
*/
select getdate()
select datepart(mm,getdate())
select datepart(yy,getDate())
select datepart(dd,getdate())
select datepart(dy,getdate())
select datepart(wk,getdate())
select datepart(dw,getdate())
select datepart(qq,getdate())
select datepart(hh,getdate())
select datepart(mi,getdate())
select datepart(ss,getdate())
select datediff(dd,getdate(),'12/25/2006')--¼ÆËã´Ó½ñÌìµ½12/25/2006»¹ÓжàÉÙÌì
select datediff(mm,getdate(),'12/25/2006')--¼ÆËã´Ó½ñÌìµ½12/25/2006»¹ÓжàÉÙ¸öÔÂ
select datename(mm,getdate())         ¡¡¡¡--ÒÔ×Ö·û´®¶ø²»ÊÇÊý×ÖµÄÐÎʽµÃµ½½ñÌìµÄÔ·ݣ¨07£©
 
select dateadd(dd,30,getdate())       ¡¡¡¡--ÔÚĿǰµÄÈÕÆÚÈÕÆÚÉϼÓ30Ìì
select dateadd(mm,3,getdate())        ¡¡¡¡--ÔÚĿǰµÄÈÕÆÚÈÕÆÚÉϼÓ3¸öÔÂ
select dateadd(yy,1,getdate())        ¡¡¡¡--ÔÚĿǰµÄÈÕÆÚÈÕÆÚÉϼÓ1Äê
select DATEADD(qq,DATEDIFF(qq,0,getdate()), 0)--µÃµ½±¾¼¾¶ÈµÚÒ»Ìì
select dateadd(mm,-3,DATEADD(qq,  DATEDIFF(qq,0,getdate()),  0)) --µÃµ½ÉÏÖ÷¡¢¼¾¶ÈµÚÒ»Ìì--ÁíÍâʹÓÃgetdate()
º¯Êý·µ»ØµÄÈÕÆÚ°üÀ¨µ½ºÁÃë¼¶£¬ÓÐʱÎÒÃÇÖ»ÐèҪȡ³öÒ»²¿·ÖÈç 200


Ïà¹ØÎĵµ£º

sys.columns £¨SQL Server 2005 £©

Ϊ°üº¬ÁеĶÔÏó£¨ÈçÊÓͼ»ò±í£©µÄÿÁзµ»ØÒ»ÐС£ÏÂÃæÊǰüº¬ÁеĶÔÏóÀàÐ͵ÄÁÐ±í¡£
±íÖµ³ÌÐò¼¯º¯Êý (FT)
ÄÚÁª±íÖµ SQL º¯Êý (IF)
ÄÚ²¿±í (IT)
ϵͳ±í (S)
±íÖµ SQL º¯Êý (TF)
Óû§±í (U)
ÊÓͼ (V)
ÁÐÃû Êý¾ÝÀàÐÍ ËµÃ÷
object_id
int
´ËÁÐËùÊô¶ÔÏóµÄ ID¡£
name
sysname
ÁÐÃû¡£ÔÚ¶ÔÏóÖÐÊÇΨһµÄ¡£
column_id
in ......

sys.identity_columns (sql server 2005)

sys.identity_columns
ÓÃ×÷±êʶÁеÄÿÁж¼ÔÚ±íÖÐÕ¼Ò»ÐС£
ÁÐÃû Êý¾ÝÀàÐÍ ËµÃ÷
<´Ó sys.columns ¼Ì³ÐµÄÁÐ>
ÓйشËÊÓͼËù¼Ì³ÐÁеÄÁÐ±í£¬Çë²ÎÔÄ sys.columns
seed_value
sql_variant
¸Ã±êʶÁеÄÖÖ×ÓÖµ¡£ÖÖ×ÓÖµµÄÊý¾ÝÀàÐÍÓëÁб¾ÉíµÄÊý¾ÝÀàÐÍÏàͬ¡£
increment_value
sql_variant
¸Ã±êʶÁеÄÔöÁ¿Öµ¡£ÖÖ×ÓÖµµÄÊ ......

SQL²Ù×÷2

ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ 
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(Create£¬Alter£¬Drop£¬DECLARE) 
DML—Êý¾Ý²Ù×ÝÓïÑÔ(Select£¬Delete£¬Update£¬Insert) 
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
Create&nb ......

ËѼ¯µÄһЩLINQ to SQLµÄ×ÊÁÏ

MSDN: http://msdn.microsoft.com/en-us/library/bb386976.aspx £¨Ó¢ÎÄ£©
           http://msdn.microsoft.com/zh-cn/library/bb386976.aspx £¨ÖÐÎÄ£©
ScottGu µÄLINQ ϵÁУº
Part 1: Introduction to LINQ to SQL
Part 2: Defining our Dat ......

sqlʹÓÃUNION

´´½¨×éºÏ²éѯ
¿ÉÓÃUNION²Ù×÷·ûÀ´×éºÏÊýÌõSQL²éѯ¡£ÀûÓÃUNION£¬¿É¸ø³ö¶àÌõSELECTÓï¾ä£¬½«ËüÃǵĽá¹û×éºÏ³Éµ¥¸ö½á¹û¼¯¡£
16.2.1 ʹÓÃUNION
UNIONµÄʹÓúܼòµ¥¡£ËùÐè×öµÄÖ»ÊǸø³öÿÌõSELECTÓï¾ä£¬ÔÚ¸÷ÌõÓï¾äÖ®¼ä·ÅÉϹؼü×ÖUNION¡£
¾ÙÒ»¸öÀý×Ó£¬¼ÙÈçÐèÒª¼Û¸ñСÓÚµÈÓÚ5µÄËùÓÐÎïÆ·µÄÒ»¸öÁÐ±í£¬¶øÇÒ»¹Ïë°üÀ¨¹©Ó¦ÉÌ1001ºÍ1002É ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ