posts - 18, 
comments - 0, 
trackbacks - 0


          
	

          


          
	
					


          
	
	
          

           1aggregate_func_name
           2    :    "sum"     | "求和"
           3    |    "avg"     | "求平均數"
           4    |    "max"     | "求最大值"
           5    |    "min"     | "求最小值"
           6    |    "count" | "求記錄數"
           7    ;
           8
           9number_function
          10    :    "abs"         |     "取絕對值"
          11    |    "acos"        |    "求值的余弦角"
          12    |    "asin"        |    "求值的正弦角"
          13    |    "atan"        |    "求值的正切角"
          14    |    "atin2"        |    "求值的正弦和余弦角"
          15    |    "ceiling"    |    "求五入后的整數"
          16    |    "cos"        |    "求角的余弦值"
          17    |    "cot"        |    "求角的余切值"
          18    |    "degrees"    |    "求弧度數的角大小"
          19    |    "exp"        |    "求冪值"
          20    |    "floor"        |    "求四舍后的整數"
          21    |    "log"        |    "求自然對數"
          22    |    "log10"        |    "求10為底的對數"
          23    |    "mod"        |    "求模"
          24    |    "pi"        |    "求PI"
          25    |    "power"        |    "求數字的次冪值"
          26    |    "radians"    |    "求度數角的弧度"
          27    |    "rand"        |    "求0和1間的隨機數"
          28    |    "round"        |    "格式化數值"
          29    |    "sign"        |    "求值的符號"
          30    |    "sin"        |    "求角的正弦值"
          31    |    "sqrt"         |     "求平方根"
          32    |    "tan"        |    "求角的正切值"
          33    ;
          34
          35string_function
          36    :    "ascii"        |    "求第一個字符的ASCII碼"
          37    |    "char"        |    "求等值的字符"
          38    |    "char_length" | "求字符串的長度"
          39    |    "charindex"    |    "存在于"
          40    |    "difference"  |    "求兩個串的差值"
          41    |    "lcase"
          42    |    "left"        |    "字符串左截"
          43    |    "length"    |    "求字符串總長度"
          44    |    "lower"     |     "將字符串轉為小寫"
          45    |    "ltrim"        |    "去掉左空格"
          46    |    "patindex"    |    "求第一次出現位置"
          47    |    "replace"    |    "字符串替換"
          48    |    "right"        |    "字符串左截"
          49    |    "rtrim"        |    "去掉右空格"
          50    |    "str"        |    "數值轉字符串"
          51    |    "substring"    |    "字符串截取"
          52    |    "upper"        |    "將字符串轉為大寫"
          53    ;
          54
          55datetime_function
          56    :    "dateformat" |    "格式化日期"
          57    |    "datename"    |    "求日期的分量值"
          58    |    "datepart"    |    "求日期的分量整數值"
          59    |    "datetime"    |    "轉為日期時間"
          60    |    "date"
          61    |    "dayname"
          62    |    "days"
          63    |    "day"
          64    |    "dow"
          65    |    "hours"
          66    |    "hour"
          67    |    "minutes"
          68    |    "minute"
          69    |    "monthname"
          70    |    "months"
          71    |    "month"
          72    |    "now"        |    "取當前日期時間"
          73    |    "quarter"
          74    |    "seconds"
          75    |    "second"
          76    |    "today"        |    "取當前日期"
          77    |    "weeks"
          78    |    "week"
          79    |    "years"
          80    |    "year"
          81    |    "getdate"    |    "求當前日期時間"
          82    |    "dateadd"    |    "日期相加"
          83    |    "datediff"    |    "日期相減"
          84    ;
          85
          86conversion_function
          87    :    "convert"    |    "字符轉為日期"
          88    |    "hextoint"    |    "十六進制轉為整數"
          89    |    "inttohex"    |    "整數轉為十六進制"
          90    |    "isdate"    |    "是日期型"
          91    |    "isnumeric"    |    "是數值型"
          92    ;
          93
          94system_function
          95    :    "suser_id"
          96    |    "suser_name"
          97    |    "user_id"
          98    |    "user_name"
          99    ;
          

	
          posted on 2007-05-16 14:10 LORD BLOG 閱讀(1727) 評論(0)  編輯  收藏  所屬分類: 數據庫相關 
          

          







          
	    
    




          





          


          

	
          
		
          
				
		
	
		
          
		
		
          只有注冊用戶登錄后才能發表評論。
          
		
          
			
		
          
			
		
          
		
		
          
		


          

		          		
		
          
		
          			
		
		
		
		
          
		
          
		
		
          
		
          
			網站導航:
		
		
          
		
          
			
		
          	
		
          
			 
		
          
		
          
			
		
          
		
          
			
				
		
          		
	
          	

          



          

				

          





    







          
        
	




主站蜘蛛池模板：
慈溪市|
赫章县|
甘洛县|
金溪县|
安远县|
渭南市|
永顺县|
林周县|
古交市|
莆田市|
小金县|
永吉县|
黎川县|
长乐市|
永济市|
辽源市|
灵璧县|
全南县|
突泉县|
温宿县|
融水|
平昌县|
诸暨市|
连山|
栾川县|
江都市|
剑阁县|
临沭县|
怀柔区|
内江市|
乳源|
田阳县|
清徐县|
西林县|
时尚|
卓资县|
宁化县|
京山县|
平南县|
广南县|
延长县|