Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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:sql server 2005Öб¸·ÝģʽÓë»Ö¸´Ä£Ê½µÄÇø±ð

»Ö¸´Ä£Ê½ÊÇÊý¾Ý¿âµÄÒ»ÖÖÌØÐÔ,Ëü¿ØÖÆ×ÅÊý¾Ý¿â±¸·ÝºÍ»¹Ô­µÄ»ù±¾ÐÐΪ.
sql server ÌṩÁËÈýÖÖ»Ö¸´Ä£Ê½,ËûÃǾö¶¨ÁËÓжàÉÙºÍʲôÑùµÄÊý¾Ý¿ÉÒÔ±»±¸·ÝÏÂÀ´.
1.¼òµ¥»Ö¸´Ä£Ê½
 Ö÷ÒªÓ¦ÓÃÓÚСÐÍÊý¾Ý¿âºÍ²»¾­³£¸Ä±äµÄÊý¾Ý
2.ÍêÕû»Ö¸´Ä£Ê½
 ¿ÉÒÔÔÚ×î´ó·¶Î§ÄÚ·ÀÖ¹³öÏÖ¹ÊÕÏʱ¶ªÊ§Êý¾Ý,Ëü°üÀ¨Êý¾Ý¿â±¸·ÝºÍʳÎïÈÕÖ¾±¸·Ý,²¢Ìá¹ ......

oracle PL/SQL FOR UPDATE Óë FOR UPDATE OFµÄÇø±ð

PL/SQL-FOR UPDATE Óë FOR UPDATE OFµÄÇø±ð
url:http://hi.baidu.com/1413/blog/item/a521251f7e5993c4a686696b.html
Êý¾Ý¿â oracle for update of   ºÍ   for updateÇø±ð    
select * from TTable1 for update Ëø¶¨±íµÄËùÓÐÐУ¬Ö»ÄܶÁ²»ÄÜд
2 select * from TTable1 wher ......

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º¯Êý left()¡¢charindex()µÄʹÓÃ

SQLº¯Êý left()¡¢charindex()µÄʹÓÃ
1¡¢left()
LEFT (<character_expression>£¬ <integer_expression>)
·µ»Øcharacter_expression ×óÆð integer_expression ¸ö×Ö·û¡£
2.charindex()
·µ»Ø×Ö·û´®ÖÐij¸öÖ¸¶¨µÄ×Ó´®³öÏֵĿªÊ¼Î»Öá£
CHARINDEX (<’substring_expression’>£¬ <expressio ......

SQLº¯Êý:ÊÂÎñʵÀý ΰÉÙÌìµØ

ÊÂÎñ¾ÍÊǸºÔð°ÑһϵÁвÙ×÷¿´×öÒ»¸ö¶ÀÁ¢µÄÂß¼­µ¥Ôª£¬ÕâЩ²Ù×÷Ҫôͬʱ³É¹¦£¬ÒªÃ´Í¬Ê±Ê§°Ü¡£ÏÂÃæÊÇÒ»¸ö¾­µäµÄÀý×Ó£º
create procedure TransferMoeny
(
    @fromAccountNo varchar(50),-- ×ª³öÕ˺Å
    @ToAccountNo varchar(50),--תÈëÕ˺Å
 & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ