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

SQL ×Ö·û´®º¯Êý

************************************************************
*
 
ASCII
--
->ASCII ( character_expression ) --->·µ»Ø×Ö·û±í´ïʽ×î×ó¶Ë×Ö·ûµÄ ASCII ´úÂëÖµ¡£
*
    
select
 
ascii
(
'
abcdef
'
)
*
 
CHAR
--
->CHAR ( integer_expression )--->½« int ASCII ´úÂëת»»Îª×Ö·ûµÄ×Ö·û´®º¯Êý¡£
*
    
SELECT
 
char
(
97
)
***************************************************************************************************************************************************************************************
*
 
NCHAR
--
->NCHAR ( integer_expression )--->¸ù¾Ý Unicode ±ê×¼Ëù½øÐе͍Ò壬Óøø¶¨ÕûÊý´úÂë·µ»Ø Unicode ×Ö·û¡£
*
    
select
 
nchar
(
31206
)
*
 
UNICODE
--
->UNICODE ( 'ncharacter_expression' )--->°´ÕÕ Unicode ±ê×¼µÄ¶¨Ò壬·µ»ØÊäÈë±í´ïʽµÄµÚÒ»¸ö×Ö·ûµÄÕûÊýÖµ¡£ 
*
    
select
 
unicode
(
'
ÇØ
'
)
***************************************************************************************************************************************************************************************
*
 
LTRIM
--
->LTRIM ( character_expression )--->ɾ³ýÆðʼ¿Õ¸ñºó·µ»Ø×Ö·û±í´ïʽ¡£
*
    
select
 
ltrim
(
'
          abcde
'
)
*
 
RTRIM
--
->RTRIM ( character_expression ) --->½Ø¶ÏËùÓÐÎ²Ëæ¿Õ¸ñºó·µ»ØÒ»¸ö×Ö·û´®¡£
*
    
select
 
rtrim
(
'
abcde      
'
)
***************************************************************************************************************************************************************************************
*
 
LOWER
--
->LOWER ( c


Ïà¹ØÎĵµ£º

SQL LIKE ͨÅä·ûËæ±Ê £¨SqlServer£©

ͨÅä·û ˵Ã÷
_    ÓëÈÎÒâµ¥×Ö·ûÆ¥Åä
 
%    Óë°üº¬Ò»¸ö»ò¶à¸ö×Ö·ûµÄ×Ö·û´®Æ¥Åä
 
[ ]  ÓëÌØ¶¨·¶Î§£¨ÀýÈ磬[a-f]£©»òÌØ¶¨¼¯£¨ÀýÈ磬[abcdef]£©ÖеÄÈÎÒâµ¥×Ö·ûÆ¥Åä¡£
 
[^]  ÓëÌØ¶¨·¶Î§£¨ÀýÈ磬[^a-f]£©»òÌØ¶¨¼¯£¨ÀýÈ磬[^abcdef]£©Ö®ÍâµÄÈÎÒâµ¥×Ö·ûÆ¥Åä¡£
......

SQL´æ´¢¹ý³Ì

ʾÀý
A. ʹÓôøÓи´ÔÓ SELECT Óï¾äµÄ¼òµ¥¹ý³Ì
ÏÂÃæµÄ´æ´¢¹ý³Ì´ÓËĸö±íµÄÁª½ÓÖзµ»ØËùÓÐ×÷Õߣ¨ÌṩÁËÐÕÃû£©¡¢³ö°æµÄÊé¼®ÒÔ¼°³ö°æÉç¡£¸Ã´æ´¢¹ý³Ì²»Ê¹ÓÃÈκβÎÊý¡£
USE pubs
IF EXISTS (SELECT name from sysobjects
         WHERE name = 'au_info_all' AND type = 'P')
&nb ......

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 ......

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

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

sql sever 2005 saĬÈÏÃÜÂëÊǶàÉÙ

Ê×ÏÈ£¬ÓÃwindows Éí·ÝÑéÖ¤ µÇ½ sql server 2005
ÒÀ´ÎÕ¹¿ª 
°²È«ÐÔ->µÇ¼Ãû
Ñ¡ÖÐ sa ÓÒ¼üµ¥»÷
Ñ¡ÖÐ ÊôÐÔ
µ¯³ö sa µÄÊôÐÔ¶Ô»°¿ò
¾ÍÔÚÃÜÂë´¦ ¸Ä ÃÜÂë ÐÐÁË
¸ÄÁËÃÜÂëºó Óà sa ºÍ Äã¸ÄµÄÃÜÂëµÇ½
Èç¹û»¹µÇ½²»ÉÏ
¾ÍÊÇÄãû´ò¿ª sql serverºÍ windowsÉí·ÝÑéÖ¤
ºÍûÊÚÓè sa µÇ½ȨÏÞ
½â¾ö°ì·¨ÈçÏÂ
£º£º£º£º ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ