SQL Server ゼロ埋め
http://msdn.microsoft.com/ja-jp/library/ms189826.aspx
convert(varchar(10), right('0000000000' + convert(varchar(10), num_column),10)) zero_padding_num_column
http://msdn.microsoft.com/ja-jp/library/ms189826.aspx
convert(varchar(10), right('0000000000' + convert(varchar(10), num_column),10)) zero_padding_num_column
YAGI Hiroto (piroto@a-net.email.ne.jp)
twitter http://twitter.com/pppiroto
Copyright© 矢木 浩人 All Rights Reserved.