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
Ïà¹ØÎĵµ£º
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 ......
1.ʹÓÃManagement Studio Express£¬ÓÓWindowsÉí·ÝÑéÖ¤”µÇ¼£¬Ñ¡ÖÐSQL·þÎñÆ÷Ãû£¬ÓÒ»÷Êó±êÑ¡ÔñÊôÐÔ£¬ÔÚ·þÎñÆ÷ÊôÐÔÑ¡ÏîÒ³Ãæ£¬Ñ¡Ôñ“°²È«ÐÔ”£¬½«·þÎñÆ÷Éí·ÝÑéÖ¤ÓÉ“WindowsÉí·ÝÑéÖ¤”¸ÄΪ“SQL ServerºÍWindowsÉí·ÝÑéÖ¤”£¬µ¥»÷È·¶¨¡£
2.ʹÓÃSQL Server 2005ÍâΧӦÓà ......
ÎÒÃÇͨ³£ÔÚ¶¨Î»Êý¾Ý¿âËøÎÊÌâʱ£¬Í¨³£Ï£ÍûÕÒµ½Äĸö½ø³Ì·¢³öÁËÄĸöÓï¾ä£¬Ëø×¡ÁËÄÄÕÅ±í£¬Ò»°ãÎÒÃÇͨ¹ý²év$lock£¬È»ºóÕÒµ½sid,ÔÙµ½v$sesionÀïÕÒµ½Õâ¸ö½ø³ÌµÄhash_value»òpre_hash_value,È»ºó¸ù¾Ýhash_value¶¨Î»µ½¾ßÌåµÄÓï¾ä¡£
¿ÉÊÇ£¬ÎÒÃÇ·¢ÏÖ£¬Í¨¹ýJDBCÁ¬½ÓÉÏÀ´µÄ½ø³Ì£¬ËüµÄhash_valueÊÇ0,ËùÒÔÎÒÃǾÍÎÞ·¨¶¨Î»Õâ¸ö½ø³ÌÖ´ÐеÄÓï¾ ......
±¾ÒëÎ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
Ò» ......
Ê×ÏÈ£¬ÓÃwindows Éí·ÝÑéÖ¤ µÇ½ sql server 2005
ÒÀ´ÎÕ¹¿ª
°²È«ÐÔ->µÇ¼Ãû
Ñ¡ÖÐ sa ÓÒ¼üµ¥»÷
Ñ¡ÖÐ ÊôÐÔ
µ¯³ö sa µÄÊôÐÔ¶Ô»°¿ò
¾ÍÔÚÃÜÂë´¦ ¸Ä ÃÜÂë ÐÐÁË
¸ÄÁËÃÜÂëºó Óà sa ºÍ Äã¸ÄµÄÃÜÂëµÇ½
Èç¹û»¹µÇ½²»ÉÏ
¾ÍÊÇÄãû´ò¿ª sql serverºÍ windowsÉí·ÝÑéÖ¤
ºÍûÊÚÓè sa µÇ½ȨÏÞ
½â¾ö°ì·¨ÈçÏÂ
£º£º£º£º ......