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

¹ØÓÚSQLµÄ×óÓÒÁ¬½Ó²éѯ

Ò»Ö±ÒÔÀ´¶ÔÓÚSQLµÄ²éѯ¶¼Ã»ÔõôÔÚÒ⣬½ñÌìÓöµ½Ò»¸ö¹ØÓÚ×óÁ¬½Ó²éѯµÄÎÊÌâ¡£
Select  uId ,uName,dpName
from users
left join dpart
on  users.pid=1 where u.pid=dpart.pid
½á¹ûÊǰÑusersËùÓнá¹û²éѯ³öÀ´£¬¶ø²»ÊÇpidΪ1µÄÓû§
Ô­À´onºóÃæ±ØÐë·ÅÁ¬½ÓÌõ¼þ£¬ÆäËûµÄÌõ¼þ·ÅÔÚwhereÀïÃæ
¸ÐлÏÄ»¶Ìá³ö


Ïà¹ØÎĵµ£º

SQL Server 2008 Books Online (November 2009)

ÈôÒªÊÕËõÌØ¶¨Êý¾Ý¿âµÄËùÓÐÊý¾ÝºÍÈÕÖ¾Îļþ£¬ÇëÖ´ÐÐ DBCC SHRINKDATABASE ÃüÁî¡£ÈôÒªÒ»´ÎÊÕËõÒ»¸öÌØ¶¨Êý¾Ý¿âÖеÄÒ»¸öÊý¾Ý»òÈÕÖ¾Îļþ£¬ÇëÖ´ÐÐ DBCC SHRINKFILE
ÃüÁî¡£
ÈôÒª²é¿´Êý¾Ý¿âÖе±Ç°µÄ¿ÉÓã¨Î´·ÖÅ䣩¿Õ¼äÁ¿£¬ÇëÔËÐÐ sp_spaceused
¡£
¿ÉÔÚ½ø³ÌÖеÄÈÎÒ»µãÍ£Ö¹ DBCC SHRINKDATABASE ²Ù×÷£¬ÈκÎÒÑÍê³ÉµÄ¹¤×÷¶¼½«±£Áô¡£ ......

[ÍÆ¼ö] Éî¶È¶Ô±ÈOracleÓëSQL Server [1]

±¾ÒëÎIJÉÓÃ֪ʶ¹²ÏíÊðÃû-·ÇÉÌÒµÐÔʹÓÃ-Ïàͬ·½Ê½¹²Ïí 3.0 UnportedÐí¿ÉЭÒé·¢²¼£¬×ªÔØÇë±£Áô´ËÐÅÏ¢
ÒëÕߣºÂí³ÝÜÈ | Á´½Ó£ºhttp://www.dbabeta.com/2010/oracle-sql-server-comparison-i.html
×÷ÕߣºSadequl Hussain | Ô­ÎÄ£ºhttp://www.sql-server-performance.com/articles/dba/oracle_sql_server_comparison_p1.aspx
Ò» ......

Óû§saµÇ¼ʧ°Ü,¸ÃÓû§Óë¿ÉÐÅsql serverÁ¬½ÓÎÞ¹ØÁª

½ñÌì²âÊÔwebÏîĿн¨ÁËÒ»¸öÊý¾Ý¿â£¬½á¹û±¨´í,ÒÔǰµÇ¼ֱ½ÓÑ¡Ôñ'WindowsÉí·ÝÑéÖ¤',²¢Ã»ÓÐʲôÎÊÌâ³öÏÖ!¿Éǰ¶Îʱ¼ä²ÉÓÃ'SQLSERVERÉí·ÝÑéÖ¤'È¥µÇ¼,ËæÖ®µÄÎÊÌâ¾ÍÀ´ÁË.ÎÞÂÛÓÃʲô·½·¨¾ÍÊÇÒ»¸ö½á¹û³ö´í! ³ö´íµÄÔ­ÒòÊÇ:'Óû§ 'sa' µÇ¼ʧ°Ü¡£¸ÃÓû§Óë¿ÉÐÅ SQL Server Á¬½ÓÎÞ¹ØÁª'.½ñÌìÉÏÍøÉϲéÁ˰ëÌ컹ÊǸ㲻¶¨,×îºó¾­¹ýÍøÉϺÍÊéÉ ......

sql server 2000µ¼³ö±í½á¹¹

sql server 2000µ¼³ö±í½á¹¹
1.
SELECT   
±íÃû=case when a.colorder=1 then d.name else '' end,   
±í˵Ã÷=case when a.colorder=1 then isnull(f.value,'') else '' end,   
×Ö¶ÎÐòºÅ=a.colorder,   
×Ö¶ÎÃû=a.name,   
±êʶ=case when COLUMNPROPERTY( a.id, ......

SQL ×Ö·û´®º¯Êý

************************************************************
*
 
ASCII
--
->ASCII ( character_expression ) --->·µ»Ø×Ö·û±í´ïʽ×î×ó¶Ë×Ö·ûµÄ ASCII ´úÂëÖµ¡£
*
    
select
 
ascii
(
'
abcdef
'
)
*
 
CHAR
--
->CH ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ