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

SQL SERVER º¯Êý£¨×ª£©

SQLServer»ù±¾º¯Êý
1.×Ö·û´®º¯Êý £º
×Ö·û²Ù×÷Àà £º
upper(char_expr) תΪ´óд
lower(char_expr) תΪСд
UCase(string) ·µ»Ø Variant (String)£¬ÆäÖаüº¬×ª³É´óдµÄ×Ö·û´®¡£
LCase(string) ·µ»Ø×Ö·û´®µÄСдÐÎʽ¡£
space(int_expr) Éú³Éint_expr¸ö¿Õ¸ñ
replicate(char_expr,int_expr) ¸´ÖÆ×Ö·û´®int_expr´Î
reverse(char_expr) ·´×ª×Ö·û´®
stuff(char_expr1,start,length,char_expr2) ½«×Ö·û´®char_expr1ÖÐµÄ´Ó start¿ªÊ¼µÄlength¸ö×Ö·ûÓÃchar_expr2´úÌæ
ltrim(char_expr) rtrim(char_expr) È¥µô¿Õ¸ñ
ascii(char) char(ascii) Á½º¯Êý¶ÔÓ¦,È¡asciiÂë,¸ù¾ÝasciiÂðÈ¡×Ö·û
×Ö·û´®²éÕÒ £º
charindex(char_expr,expression) ·µ»Øchar_exprµÄÆðʼλÖÃ
patindex("%pattern%",expression) ·µ»ØÖ¸¶¨Ä£Ê½µÄÆðʼλÖÃ,·ñÔòΪ0
locate(substr,str,pos) ·µ»Ø×Ó´®substrÔÚ×Ö·û´®strµÚÒ»¸ö³öÏÖµÄλÖÃ
2.Êýѧº¯Êý
abs(numeric_expr) Çó¾ø¶ÔÖµ
ceiling(numeric_expr) È¡´óÓÚµÈÓÚÖ¸¶¨ÖµµÄ×îСÕûÊý
exp(float_expr) È¡Ö¸Êý
floor(numeric_expr) СÓÚµÈÓÚÖ¸¶¨ÖµµÃ×î´óÕûÊý
power(numeric_expr,power) ·µ»Øpower´Î·½
rand([int_expr]) Ëæ»úÊý²úÉúÆ÷
round(numeric_expr,int_expr) °²int_expr¹æ¶¨µÄ¾«¶ÈËÄÉáÎåÈë
sign(int_expr) ¸ù¾ÝÕýÊý,0,¸ºÊý,,·µ»Ø+1,0,-1
sqrt(float_expr) ƽ·½¸ù
exp(float x):ÇóeµÄx´ÎÃÝ
tan(float x)£º¼ÆËãx£¨»¡¶È±íʾ£©µÄÕýÇÐÖµ¡£
atan(float x):Çóx£¨»¡¶È±íʾ£©µÄ·´ÕýÇÐÖµ
cos(float x):Çóx£¨»¡¶È±íʾ£©µÄÓàÏÒÖµ
acos(float x):Çóx£¨»¡¶È±íʾ£©µÄ·´ÓàÏÒÖµ
sin(float x):¼ÆËãx£¨»¡¶È±íʾ£©µÄÕýÏÒÖµ¡£
asin(float x):Çóx£¨»¡¶È±íʾ£©µÄ·´ÕýÏÒÖµ
fabs(float x):Ç󸡵ãÊýxµÄ¾ø¶ÔÖµ
fmod(float x, float y):¼ÆËãx/yµÄÓàÊý
pow(float x, float y):¼ÆËãxµÄy´ÎÃÝ¡£
sqrt(float x)£º¼ÆËãxµÄƽ·½¸ù¡£
3.ÈÕÆÚ£¬Ê±¼äº¯Êý
getdate() ·µ»ØÈÕÆÚ
datename(datepart,date_expr) ·µ»ØÃû³Æ
datepart(datepart,date_expr) È¡ÈÕÆÚÒ»²¿·Ý
datediff(datepart,date_expr1.dateexpr2) ÈÕÆÚ²î
dateadd(datepart,number,date_expr) ·µ»ØÈÕÆÚ¼ÓÉÏ number
4.ϵͳº¯Êý
suser_name() Óû§µÇ¼Ãû
user_name() Óû§ÔÚÊý¾Ý¿âÖеÄÃû×Ö
user Óû§ÔÚÊý¾Ý¿âÖеÄÃû×Ö
show_role() ¶Ôµ±Ç°Óû§Æð×÷ÓõĹæÔò
db_name() Êý¾Ý¿âÃû
object_name(obj_id) Êý¾Ý¿â¶ÔÏóÃû
col_name(obj_id,col_id) ÁÐÃû
col_le


Ïà¹ØÎĵµ£º

hibernate ´òÓ¡SQLÓï¾äµ½¿ØÖÆ̨

Ö»ÐèÒªÔÚÅäÖÃÎļþÀï         hibernate.show_sql=true
    <property name="hibernateProperties">
      <value>
        hibernate.dialect=org.hibernate.dialect.Oracle9Dialect ......

(ÍøÕª)SQL·ÖÒ³Óï¾ä


֮ǰżȻ¹äÍøÒ³µÄʱºò¿´µ½µÄ,ÏêϸµÄÍøÖ·Íü¼Çcopy¹ýÀ´ÁË£¬ÕæÊDZ§Ç¸¡£¾õµÃ¼òµ¥Ò׶®,ËùÒÔתÁË,ÎûÎû
ÓйطÖÒ³ SQL µÄ×ÊÁϺܶ࣬ÓеÄʹÓô洢¹ý³Ì£¬ÓеÄʹÓÃÓαꡣ±¾È˲»Ï²»¶Ê¹ÓÃÓα꣬ÎÒ¾õµÃËüºÄ×Ê¡¢Ð§Âʵͣ»Ê¹Óô洢¹ý³ÌÊǸö²»´íµÄÑ¡Ôñ£¬ÒòΪ´æ´¢¹ý³ÌÊǾ­¹ýÔ¤±àÒëµÄ£¬Ö´ÐÐЧÂʸߣ¬Ò²¸üÁé»î¡£ÏÈ¿´¿´µ¥Ìõ SQL Óï¾äµÄ·ÖÒ³ SQL ......

Sql½ØÈ¡×Ö·û

 ×öÏîÄ¿ÀïÃæµÄÊý¾Ý¿âÉè¼ÆÁËÁ½¸öÀàÐÍ·ÅÒ»¸ö×Ö¶ÎÀïÃæ,ÎÒÓÖҪͨ¹ý·Ö¿ªµÄÀàÐÍÀ´½øÐвéѯ,Í´¿à°¡,
Á½ÖÖ·½·¨;
1,¶ÁÈ¡µ½»º´æÖÐ×Ô¶¨Òådatatable, ´úÂë¾Í²»ÌùÁË.
²»ÐÀÉÍÕâÖÖ×ö·¨,ÒòΪÎÒÒѾ­°ÑÒ³ÃæÉϺܶණÎ÷дÁË,¶¼ÊÇÓеÄSqlÓï¾ä,ÕâÑù¸Äһ϶¼Òª¸ÄÁË.
2.Ö±½ÓÔÚSqlÀïÃ潨ÊÓͼ,
lÓÃSUBSTRING(dbo.K_ProductDtl.Caizhi, 0, CH ......

SQL 2005 °²×°

ÏÂÔØsql2005ÍêÒÔºó½âѹ³öÀ´£¬´ó¼Ò¿ÉÒÔ¿´µ½cs_sql_2005_chs_x86Õâ¸öĿ¼£¬½øÈëÕâ¸öĿ¼ÔËÐÐsetup.exeÎļþ£¬°²×°³ÌÐò¾Í¿ªÊ¼ÔËÐÐÁË¡£
Ê×Ïȵ¯³öÀ´µÄÊÇÈí¼þÐí¿ÉÌõ¿î
¹´ÉÏÎÒ½Ó°®Ðí¿ÉÌõ¿îºÍÌõ¼þ£¬µãÏÂÒ»²½
ÕâÀïÁгöÁËSQL2005ÔËÐл·¾³£¬Ö±½Óµã°²×°
³ÌÐò¿ªÊ¼°²×°SQL2005ÔËÐбØÐèµÄ»·¾³£¬ÅäÖÃ×é¼þ
±ØÐèµÄ×é¼þ°²×°ºÃÁË£¬µãÏÂÒ»²½¼ ......

sql convertÈÕÆÚʱ¼ä¸ñʽ

--²éѯÏÖÔÚÈÕÆÚ£¬Ö»ÒªÄêÔÂÈÕ
 select convert(varchar(10),getDate(),120)
--²éѯÏÖÔÚÈÕÆÚ£¬Ö»ÒªÊ±·ÖÃë
select convert(varchar(8),getDate(),8)
Convertº¯ÊýµÄһЩ˵Ã÷£¬ÒÔÏÂ×ÊÁÏÀ´Ô´ÓÚÍøÂç
²»´øÊÀ¼ÍÊýλ (yy)
´øÊÀ¼ÍÊýλ (yyyy)

±ê×¼

ÊäÈë ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ