发表于 2009-1-5 19:48
| 
SQL SERVER 鐨勫嚱鏁
鍙戝竷: 2008-6-30 23:24 | 浣滆: admin | 鏌ョ湅: 2娆
SQL SERVER 鐨勫嚱鏁
鑽
銆愬瓧浣擄細灏 澶с
SQL SERVER 鐨勫嚱鏁
浣滆咃細- 鏂囩珷鏉ユ簮锛- 鐐瑰嚮鏁帮細403 鏇存柊鏃堕棿锛2006-4-20 
1.瀛楃涓插嚱鏁
闀垮害涓庡垎鏋愮敤
datalength(Char_expr) 杩斿洖瀛楃涓插寘鍚瓧绗︽暟,浣嗕笉鍖呭惈鍚庨潰鐨勭┖鏍
substring(expression,start,length) 涓嶅璇翠簡,鍙栧瓙涓
right(char_expr,int_expr) 杩斿洖瀛楃涓插彸杈筰nt_expr涓瓧绗
瀛楃鎿嶄綔绫
upper(char_expr) 杞负澶у啓
lower(char_expr) 杞负灏忓啓
space(int_expr) 鐢熸垚int_expr涓┖鏍
replicate(char_expr,int_expr)澶嶅埗瀛楃涓瞚nt_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) 涓ゅ嚱鏁板搴,鍙朼scii鐮,鏍规嵁ascii鍚楀彇瀛楃
瀛楃涓叉煡鎵
charindex(char_expr,expression) 杩斿洖char_expr鐨勮捣濮嬩綅缃
patindex("%pattern%",expression) 杩斿洖鎸囧畾妯″紡鐨勮捣濮嬩綅缃,鍚﹀垯涓0
2.鏁板鍑芥暟
abs(numeric_expr) 姹傜粷瀵瑰
ceiling(numeric_expr) 鍙栧ぇ浜庣瓑浜庢寚瀹氬肩殑鏈灏忔暣鏁
exp(float_expr) 鍙栨寚鏁 floor(numeric_expr) 灏忎簬绛変簬鎸囧畾鍊煎緱鏈澶ф暣鏁
pi() 3.1415926.........
power(numeric_expr,power) 杩斿洖power娆℃柟
rand([int_expr]) 闅忔満鏁颁骇鐢熷櫒
round(numeric_expr,int_expr) 瀹塱nt_expr瑙勫畾鐨勭簿搴﹀洓鑸嶄簲鍏
sign(int_expr) 鏍规嵁姝ｆ暟,0,璐熸暟,,杩斿洖+1,0,-1
sqrt(float_expr) 骞虫柟鏍
3.鏃ユ湡鍑芥暟
getdate() 杩斿洖鏃ユ湡
datename(datepart,date_expr) 杩斿洖鍚嶇О濡 June
datepart(datepart,date_expr) 鍙栨棩鏈熶竴閮ㄤ唤
datediff(datepart,date_expr1.dateexpr2) 鏃ユ湡宸
dateadd(datepart,number,date_expr) 杩斿洖鏃ユ湡鍔犱笂 number
涓婅堪鍑芥暟涓璬atepart鐨 鍐欐硶 鍙栧煎拰鎰忎箟
yy 1753-9999 骞翠唤
qq 1-4 鍒
mm 1-12 鏈
dy 1-366 鏃
dd 1-31 鏃
wk 1-54 鍛
dw 1-7 鍛ㄥ嚑
hh 0-23 灏忔椂
mi 0-59 鍒嗛挓
ss 0-59 绉
ms 0-999 姣
鏃ユ湡杞崲 convert()
4.绯荤粺鍑芥暟
suser_name() 鐢ㄦ埛鐧诲綍鍚
user_name() 鐢ㄦ埛鍦ㄦ暟鎹簱涓殑鍚嶅瓧 user 鐢ㄦ埛鍦ㄦ暟鎹簱涓殑鍚嶅瓧
show_role() 瀵瑰綋鍓嶇敤鎴疯捣浣滅敤鐨勮鍒
db_name() 鏁版嵁搴撳悕
object_name(obj_id) 鏁版嵁搴撳璞″悕
col_name(obj_id,col_id) 鍒楀悕
col_length(objname,colname) 鍒楅暱搴
valid_name(char_expr) 鏄惁鏄湁鏁堟爣璇嗙
Copyright 2003-2005 www.sohozu.com All Rights Reserved
