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

Win7ϰ²×°SQL Server2005

ÔÚWin7ϰ²×°SQL2005¿ª·¢°æ£¬°²×°SQL Native ClientʱÌáʾ°²×°Öжϣ¬Ã»ÓÐÔÚÒ⣬ȻºóÔÚ°²×°SQL ServerʱÓÖÌáʾ“[Microsoft][SQL Native Client]¿Í»§¶Ë²»Ö§³Ö¼ÓÃÜ.SQL Server °²×°³ÌÐòÎÞ·¨Á¬½Óµ½Êý¾Ý¿â·þÎñ½øÐзþÎñÆ÷ÅäÖÃ.”Ð¶ÔØSQL Native ClientÖØÐ°²×°£¬»¹ÊÇÖжϣ¬ÐÞ¸´£¬Ò²Öжϣ¬ÔÙÐ¶ÔØ£¬ÇåÀí×¢²á±í£¬ÖØ×°»¹ÊÇÕâ¸öÎÊÌ⣬ºóÀ´ÓÃħ·½½øÐÐÈí¼þÐ¶ÔØ¡¢ÐÞ¸´£¬¾¹È»È´³É¹¦ÁË¡£¹ÖÊÂ~~
ÔÙ°²×°SQL Server ¾ÍûÓÐÌáʾÁË£¬°²×°³É¹¦¡£È»ºó´òÉÏSP3µÄ²¹¶¡£¬²¹¶¡¼´½«½áÊøÊ±»áÌáʾÓû§½øÐÐȨÏÞÉèÖá£
¸½¼ÓÊý¾Ý¿â£¬OK£¡


Ïà¹ØÎĵµ£º

¡¾¸´Ï°¡¿SQL ÄÚ£¬Í⣬×ó£¬ÓÒÁ¬½Ó

ÐÅÏ¢±í(infor)¹¤×ʱí(pay)
ÄÚÁ¬½Ó
select pay.name,infor.AGE,PAY.MONEY,infor.email from pay  join infor on infor.name=PAY.name
×óÍâÁ¬½Ó
select pay.name,infor.AGE,PAY.MONEY,infor.email from pay  left join infor on infor.name=PAY.name
PS£º½á¹ûÓÐÍõÎ壬¹¤×ÊΪ0
ÓÒÍâÁ¬½Ó
select pay.name,info ......

sqlµÄ±íĿ¼ÊÓͼ

sysaltfiles   ÔÚmasterÊý¾Ý¿âÖУ¬°üº¬ÓëÊý¾Ý¿âÎļþÏà¶ÔÓ¦µÄÐÅÏ¢£¬°üº¬ËùÓÐÊý¾Ý¿âµÄÊý¾ÝÎļþÒÔ¼°ÈÕÖ¾Îļþ
ÁÐÃûÊý¾ÝÀàÐÍÃèÊö
fileid
smallint
ÿ¸öÊý¾Ý¿âµÄΨһÎļþ±êʶºÅ¡£1´ú±íÊý¾ÝÎļþ£¬2´ú±íÈÕÖ¾Îļþ
groupid
smallint
Îļþ×é±êʶºÅ¡£
size
int
Îļþ´óС£¨ÒÔ 8 KB ҳΪµ¥Î»£©¡£Ò³µÄÊýÄ¿
maxsize
......

Ö´ÐдøÇ¶Èë²ÎÊýµÄsql——sp_executesql

ͨ³£Ö´ÐÐsqlÓï¾ä£¬´ó¼ÒÓõͼÊÇexec£¬exec¹¦ÄÜÇ¿´ó£¬µ«²»Ö§³ÖǶÈë²ÎÊý£¬sp_executesql½â¾öÁËÕâ¸öÎÊÌâ¡£³­Ò»¶Îsqlserver°ïÖú£º
sp_executesql
Ö´ÐпÉÒÔ¶à´ÎÖØÓûò¶¯Ì¬Éú³ÉµÄ Transact-SQL Óï¾ä»òÅú´¦Àí¡£Transact-SQL Óï¾ä»òÅú´¦Àí¿ÉÒÔ°üº¬Ç¶Èë²ÎÊý¡£
Óï·¨
sp_executesql
[@stmt
=
] stmt
[
   &n ......

SQL SERVER¿ì½Ý¼ü

                                                   ......

MS SQL Server ¡¢Sybase¡¢ OracleÖ§³ÖËø¶¨·½°¸µÄ²»Í¬

»¹ÊǼ¸Î»¶ÁÎÒµÄÊé (¡¶Oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIX UNIXÉϵÄʵսÏê½â¡·) µÄ¶ÁÕßÀ´Óʼþ×ÉѯÎÊÌ⣬ºÜ±§Ç¸ÎÒ²»ÄÜÖðλ»Ø¸´Óʼþ£¬µÚÒ»ÎÒÕæµÄͦ棬µÚ¶þÕâЩÎÊÌâÆÄÓй²ÐÔ¡£ÎÒÀ´½èÖúÕâ¸öµØ·½£¬Í³Ò»µØºÍÖîλ̽ÌÖ£¬ºÜ¶àÎÊÌâÎÒÒ²ÊÇÔÚÃþË÷ÖУ¬²»ÄÜÖ±½Ó¸ø´ó¼Ò´ð°¸£¬ºÇºÇ£¬´ó¼Ò¼ûÁ°¡!

ËµËµËøÎÊÌâ¡£ MS SQLÖ§³ÖµÄËøÀàÐͺÍOracle²îÒìÊǺ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ