Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

MySQL5.1ÄÚ±íתµ½MS SQL£¬±í½á¹¹Ó¦ÈçºÎÉèÖã¿

# MySQL-Front 5.1  (Build 4.2)
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */ ......

sql:sql server 2005Öб¸·ÝģʽÓë»Ö¸´Ä£Ê½µÄÇø±ð

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

Truncate Logs for SQL Server 2008

Truncate Logs for SQL Server 2008
I had previously posted how to Truncate Logs for SQL Server 2005. Unfortunately, this method does not work in SQL Server 2008. The reason is because the “WITH TRUNCATE_ONLY” command is no longer in SQL 2008. Assuming you run in full recovery mode, the n ......

SQLº¯Êý left()¡¢charindex()µÄʹÓÃ

SQLº¯Êý left()¡¢charindex()µÄʹÓÃ
1¡¢left()
LEFT (<character_expression>£¬ <integer_expression>)
·µ»Øcharacter_expression ×óÆð integer_expression ¸ö×Ö·û¡£
2.charindex()
·µ»Ø×Ö·û´®ÖÐij¸öÖ¸¶¨µÄ×Ó´®³öÏֵĿªÊ¼Î»Öá£
CHARINDEX (<’substring_expression’>£¬ <expressio ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ