from the MSSQL manual
When a parameter of the function has a default value, the keyword “default” must be specified
when calling the function in order to get the default value.
This behavior is different from parameters with default values in stored procedures
in which omitting the parameter also implies the default value.
Source: http://forums.devshed.com/ms-sql-development-95/optional-parameters-on-create-function-149019.html
Please move to the original source for these articals, thanks.
Part 1. Build your own data source for DataFormWebPart
Part 2. Use XSLT generated from SharePoint Designer to display data
Part 3. Filtering on column headers problem
| mso-number-format:”0″ | NO Decimals |
| mso-number-format:”0\.000″ | 3 Decimals |
| mso-number-format:”\#\,\#\#0\.000″ | Comma with 3 dec |
| mso-number-format:”mm\/dd\/yy” | Date7 |
| mso-number-format:”mmmm\ d\,\ yyyy” | Date9 |
| mso-number-format:”m\/d\/yy\ h\:mm\ AM\/PM” | D -T AMPM |
| mso-number-format:”Short Date” | 01/03/1998 |
| mso-number-format:”Medium Date” | 01-mar-98 |
| mso-number-format:”d\-mmm\-yyyy” | 01-mar-1998 |
| mso-number-format:”Short Time” | 5:16 |
| mso-number-format:”Medium Time” | 5:16 am |
| mso-number-format:”Long Time” | 5:16:21:00 |
| mso-number-format:”Percent” | Percent – two decimals |
| mso-number-format:”0%” | Percent – no decimals |
| mso-number-format:”0\.E+00″ | Scientific Notation |
| mso-number-format:”\@” | Text |
| mso-number-format:”\#\ ???\/???” | Fractions – up to 3 digits (312/943) |
| mso-number-format:”\0022£\0022\#\,\#\#0\.00″ | £12.76 |
| mso-number-format:”\#\,\#\#0\.00_ \;\[Red\]\-\#\,\#\#0\.00\ “ | 2 decimals, negative numbers in red and signed (1.56 -1.56) |
用法举例：
当我们用<%@page contentType=”application/vnd.ms-excel; charset=UTF-8″%>的方法导出网页文件为excel时，如果导出的数据中有数字以0开头，则该0会被省略，为了保留这个处于首位的0，可以在表格的style中加入：
style=’mso-number-format:”\@”;’
这样的话，导出的该表格中首位为0的数字就会将该0保留啦！
来源: http://blog.sina.com.cn/s/blog_5a010cd10100c3gs.html