圭臬

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

create table aaa
(
col nvarchar(10)
)
insert into aaa
select 1
union
select 2
union
select 3
declare @sql varchar(8000)
set @sql=’select ‘
select  @sql=@sql+’max(case col when ”’+ col +”’ then col end) + ”,” + ‘
from (select distinct col from aaa)  a
set @sql=left(@sql,len(@sql)-1)
set @sql=@sql+’  from aaa’
–print @sql
exec(@sql)
drop table aaa

public void EnumInstanceFromInt()
{
// The .NET Framework contains an Enum called DayOfWeek.
// Let’s generate some Enum instances from int values.
// Usually you wouldn’t cast an instance of an existing Enum to an int
// in order to create an Enum instance. You would have the actual
// integer value, perhaps a value from a database [...]

Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Test]
@=”Test”
“URL Protocol”=”应用程序路径 %l”
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Test\DefaultIcon]
@=”%SystemRoot%\\system32\\url.dll,0″
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Test\Shell]
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Test\Shell\open]
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Test\Shell\open\command]
@=”应用程序路径 %l”
注意: %1是百分号加上数字1
在网页上加一个这样的链接：
<a href=’Test://para1&para2&para3′>启动桌面应用程序</a>
如果用户点击这个网页链接，在注册表中对应的应用程序就可以被启动了。
来源: http://www.cnblogs.com/ilovejolly/archive/2007/06/25/794566.html

DateTime.ParseExact(输入的字符串,”yyyyMMdd”,System.Globalization.CultureInfo.CurrentCulture)