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

ÕûÀíһϣ¬¹ØÓÚÓα꣬MSDNÓУº
¹ý Transact-SQL ·þÎñÆ÷Óαê¼ìË÷ÌØ¶¨ÐС£
Transact-SQL Óï·¨Ô¼¶¨
 ²ÎÊý
NEXT
½ô¸úµ±Ç°Ðзµ»Ø½á¹ûÐУ¬²¢ÇÒµ±Ç°ÐеÝÔöΪ·µ»ØÐС£Èç¹û FETCH NEXT Ϊ¶ÔÓαêµÄµÚÒ»´ÎÌáÈ¡²Ù×÷£¬Ôò·µ»Ø½á¹û¼¯ÖеĵÚÒ»ÐС£NEXT ΪĬÈϵÄÓαêÌáȡѡÏî¡£
PRIOR
·µ»Ø½ôÁÚµ±Ç°ÐÐÇ°ÃæµÄ½á¹ûÐУ¬²¢ÇÒµ±Ç° ......

sqlserver һЩȫ¾Ö±äÁ¿

sqlserver ÖÐ È«¾Ö±äÁ¿ ÊÇÒ»ÖÖÌØÊâÀàÐ͵ıäÁ¿£¬È«¾Ö±äÁ¿ÒÔ@@¿ªÍ·£¬ÊÇÓÉϵͳ¶¨ÒåµÄ¡£
@@CONNECTIONS   ·µ»Ø
SQL Server
×ÔÉÏ´ÎÆô¶¯ÒÔÀ´³¢ÊÔµÄÁ¬½ÓÊý¡£
@@CURSOR_ROWS  
È·¶¨µ±Æä±»µ÷ÓÃʱ¼ìË÷ÁËÓαê·ûºÏÌõ¼þµÄÐÐÊý¡£
@@DATEFIRST       
Õë¶Ô»á»°·µ»Ø
S ......

°²×°SqlServer 2000ʱ³öÏÖÒì³£µÄ´¦Àí


ÏÖÏó£º
ÔÚ×°SqlServer 2000ʱ£¬ÀÏÊǵ¯³ö“ÁíÒ»¸öʵÀýÕýÔÚÔËÐДµÄ´íÎóÐÅÏ¢£¬½áÊøÁ˽ø³ÌÀïsqlµÄÏà¹ØÎļþºÍɾ³ýÒÔǰ°²×°¹ýµÄ°²×°Ä¿Â¼ÏµÄsqlÎļþºó£¬ÖØÆôµçÄÔºó°²×°»¹ÊdzöÏÖÕâÖÖÇé¿ö¡£
´¦Àí°ì·¨£º
ÕâÖÖÇé¿öÒ»°ãÊÇSqlServer 2000Ð¶ÔØ²»ÍêÈ«Ôì³ÉµÄ¡£
ÔÚ“¿ªÊ¼-ÔËÐДÖÐÊäÈëregeditµ÷³ö×¢²á±í£¬ÕÒµ½£ ......

mysql,sqlserver,oracleÈýÖÖÊý¾Ý¿âµÄ´ó¶ÔÏó´æÈ¡


mysql ´ó¶ÔÏó´æÈ¡:
ÀàÐÍÒ»°ãÓ¦¸ÃÓÃmediumblod,
blobÖ»ÄÜ´æ2µÄ16´Î·½¸öbyte,
mediumblodÊÇ24´Î·½,
Ò»°ãÀ´Ëµ¹»ÓÃÁË.longblobÊÇ32´Î·½ÓÐЩ´ó.
MYSQLĬÈÏÅäÖÃÖ»ÄÜ´æ1M´óСµÄÎļþ,ÒªÐÞ¸ÄÅäÖÃ,WIN°æ±¾µÄÔÚmysql.iniÎļþÖÐ
ÐÞ¸Ämax_allowed_packet,net_buffer_lengthµÈ¼¸¸ö²ÎÊý,»òÖ±½ÓSET GLOBAL varName=value.
linux°æ± ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ