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

SQLServerÖÐÓõıȽ϶àµÄº¯Êý

ÏÂÃæÊÇÎÒÔÚSQLServerÖÐÓõıȽ϶àµÄº¯Êý£¬Ä㻹ÓÃЩʲôº¯Êý£¿»òÕß¶ÔÄĸöº¯ÊýÓбȽϺÃÓ÷¨£¿»òÕßÄã²»ÓÃÄÄЩº¯Êý£¿
LEFT ( character_expression , integer_expression )
·µ»Ø´Ó×Ö·û´®×ó±ß¿ªÊ¼Ö¸¶¨¸öÊýµÄ×Ö·û¡£
Àý:
select left('my name is viwo',4)
my n
RIGHT ( character_expression , integer_expression )
·µ»Ø×Ö·û´®ÖдÓÓұ߿ªÊ¼Ö¸¶¨¸öÊýµÄ integer_expression ×Ö·û¡£
Àý:
select right('my name is viwo',4)
viwo
CAST ( expression AS data_type )
½«Ä³ÖÖÊý¾ÝÀàÐ͵ıí´ïʽÏÔʽת»»ÎªÁíÒ»ÖÖÊý¾ÝÀàÐÍ¡£CAST ºÍ CONVERT ÌṩÏàËÆµÄ¹¦ÄÜ¡£
Àý:
select cast(2 as varchar(10))+cast(11 as varchar(10))
211
CONVERT (data_type[(length)], expression [, style])
½«Ä³ÖÖÊý¾ÝÀàÐ͵ıí´ïʽÏÔʽת»»ÎªÁíÒ»ÖÖÊý¾ÝÀàÐÍ¡£CAST ºÍ CONVERT ÌṩÏàËÆµÄ¹¦ÄÜ¡£
Àý:
select convert(varchar,getdate(),112)
20070328
DATEADD ( datepart , number, date )
ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ¡£
Àý:
select dateadd(month,2,getdate())
2007-05-28 14:24:37.280
COALESCE ( expression [ ,...n ] )
·µ»ØÆä²ÎÊýÖеÚÒ»¸ö·Ç¿Õ±í´ïʽ¡£
Àý:
select coalesce(null,null,0)
0
select coalesce(2,3,0)
2
CHARINDEX ( expression1 , expression2 [ , start_location ] )
·µ»Ø×Ö·û´®ÖÐÖ¸¶¨±í´ïʽµÄÆðʼλÖá£
Àý:
select charindex('ab','eabcd')
2
LTRIM ( character_expression )
ɾ³ýÆðʼ¿Õ¸ñºó·µ»Ø×Ö·û±í´ïʽ¡£
Àý:
select ltrim('   abc    ')
abc        
RTRIM ( character_expression )
½Ø¶ÏËùÓÐÎ²Ëæ¿Õ¸ñºó·µ»ØÒ»¸ö×Ö·û´®¡£
Àý:
select rtrim('   abc    ')
   abc
ROUND ( numeric_expression , length [ , function ] )
·µ»ØÊý×Ö±í´ïʽ²¢ËÄÉáÎåÈëΪָ¶¨µÄ³¤¶È»ò¾«¶È¡£
Àý:
select ROUND(748.585, 2)
748.590
FLOOR ( numeric_expression )
·µ»ØÐ¡ÓÚ»òµÈÓÚËù¸øÊý×Ö±í´ïʽµÄ×î´óÕûÊý¡£
Àý:
select floor(748.585)
748
CEILING ( numeric_expression )
·µ»Ø´óÓÚ»òµÈÓÚËù¸øÊý×Ö±í´ïʽµÄ×îСÕûÊý¡£
Àý:
select ceiling(748.585)
749
REPLACE ( 'string_expression1' , 'string_expression2' , 'string_expression3' )
ÓõÚÈý¸ö±í´ïÊ½Ìæ»»µÚÒ»¸ö×Ö·û´®±í´ïʽÖ


Ïà¹ØÎĵµ£º

sqlserver´æ´¢¹ý³Ì¿½±´µ½¼Çʱ¾µÄÇé¿ö

×òÌìÉÏ´«³ÌÐòûÓгɹ¦£¬·¢ÏÖÒ»¸öÎÊÌâ
½«SQLServerµÄ´æ´¢¹ý³Ì¿½±´µ½¼Çʱ¾Ê±£¬Èç¹û¼Çʱ¾ÊÇ×Ô¶¯»Ø³µµÄ£¬ÐèҪעÒâһϲÎÊýÊÇ·ñ»Ø³µ¡£
¾ÙÀý£º
alter Proc [dbo].[aaa]
@tCardNos nvarchar(500), --Ïû·Ñ¿¨¿¨ºÅ@tCardPwds nvarchar(1000),--Ïû·Ñ¿¨¿¨ºÅ--¿¨ÃÜÂë@ProductId nvarchar(15), --²úÆ·±àºÅ
ËùÓеIJÎÊý¶¼Ô ......

sqlserver ÐÞ¸ÄÅÅÐò¹æÔò

ǰÕóÓöµ½ ±¾µØsqlserver2005¿ç¿â²éѯ
½á¹ûÊ×Ïȱ¨´íµÄÊÇ ÎÞ·¨ ´¦Àí²»Í¬µÄÅÅÐò¹æÔò
ÔÚÐÞ¸ÄÅÅÐò¹æÔòµÄ¹ý³ÌÖУ¬ÓÖ³öÏÖÁË£¬“ÎÞ·¨ÓÃÅÅËûËøËø¶¨¸ÃÊý¾Ý¿â£¬ÒÔÖ´ÐиòÙ×÷¡£”ÕâÑùµÄ´íÎó¡£
¾­²é×ÊÁÏ·¢ÏÖ£¬ÐÞ¸ÄÊý¾Ý¿âΪµ¥Óû§·ÃÎÊ£¬¿ÉÒÔËø¶¨Êý¾Ý¿â¡£
alter database yourdatabase set single_user with rollback  ......

SqlServerÃüÃû¹æ·¶

ÃüÃû¹ý³ÌÖÐÈçÓÐÏÖ´æµÄËõд£¬ÔòʹÓøÃËõд£¬ÈçÎÞ£¬Ò»Âɲ»µÃËõд£¬Àý£ºISBN
Êý¾Ý¿â£ºÓÃÒ»¸ö»òÈý¸öÒÔÏÂÓ¢Îĵ¥´Ê×é³É£¬µ¥´ÊÊ××Öĸ´óд£¬È磺DepartmentManage£»
±íÃû£ºÊ¹ÓÃÃû´ÊÐÔÖʵĵ¥´Êȫƴ±íʾ£¬¸÷µ¥´ÊÊ××Öĸ´óд£¬ ʹÓø´ÊýÐÎʽ£¬È磺Books
      Èç¹û¸Ã±íÓÃÓÚ±íÃ÷ÁíÍâÁ½±íÖÐ×ֶμäµÄ¹ØÏµ£¬Óõ ......

×ªÔØµÄһƪsqlserverÎÄÕÂ

¹«Ë¾×éÖ¯SQLˮƽ¿¼ÊÔ£¬¿´ÁËд½Ì²Ä£¬Ð´Á˵ã×ܽᷢÉÏÀ´¸ú´ó¼Ò·ÖÏí¡£
ÎÒ¹«Ë¾Ê¹ÓõÄÊÇSybase ASE12.5£¬ËùÒÔÏÂÃæµÄÒ»Ð©ÌØÐÔÊÇÕë¶ÔSybase ASEµÄ¡£
Ò»£ºSQL Bisic
1£ºSQL(Structured Quary Language)ÌØÐÔ£º
a£º±ê×¼»¯
b£º·Ç¹ý³Ì»¯µÄ
c£º¿ÉÓÅ»¯µÄ
d£ºÃæÏò¼¯ºÏ²Ù×÷µÄ
2£ºASEÖеÄÊý¾ÝÀàÐÍ
a£ºNumberic
b£ºCharacter
c£ºDa ......

sqlserverºÍoracle³£Óú¯Êý¶Ô±È

sqlserverºÍoracle³£Óú¯Êý¶Ô±È
Êýѧº¯Êý
¡¡¡¡1.¾ø¶ÔÖµ
¡¡¡¡S:select abs(-1) value
¡¡¡¡O:select abs(-1) value from dual
¡¡¡¡2.È¡Õû(´ó)
¡¡¡¡S:select ceiling(-1.001) value
¡¡¡¡O:select ceil(-1.001) value from dual
¡¡¡¡3.È¡Õû£¨Ð¡£©
¡¡¡¡S:select floor(-1.001) value
¡¡¡¡O:select floor(-1.0 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ