善用 SELECT INTO 功能 zz

Yixuan Huang — Thu, 27 Jul 2006 09:59:00 GMT

很多时候我们都需要覆制某 Table 的结构，而��?SQL Server 的话当然可以�?Enterprise Manager 来解册��问题�Q�但在操作上老是感到比较�?ch��)覆�?

其实我只需要一�?SQL 语言便能较易地覆�?Table 的结构，例如我们要覆�?Orders �?OrderHistory 的语法如下：(x��)

SELECT * INTO OrderHistory FROM Orders WHERE 0 = 1

由於 0 永远都不�?x��)等�?1 所以这�?SELECT 语法便是 0 rows 的结果，所以新�?Table: OrderHistory ��没有�Q何资料�?(当然要��?SELECT INTO 的话��必��d��?sp_dboption 讑֮��?true)

http://news.hackhome.com/html/jskf/aspjc/2006/0612/32715.html

Yixuan Huang 2006-07-27 17:59 发表评论

code

Yixuan Huang — Sun, 23 Jul 2006 15:28:00 GMT

  1 package test.format;
  2 import java.text.NumberFormat;
  3 import java.util.HashMap;
  4 public class SimpleMoneyFormat {
  5   public static final String EMPTY = "";
  6   public static final String ZERO = "�?/span>";
  7   public static final String ONE = "�?/span>";
  8   public static final String TWO = "�?/span>";
  9   public static final String THREE = "�?/span>";
10   public static final String FOUR = "�?/span>";
11   public static final String FIVE = "�?/span>";
12   public static final String SIX = "�?/span>";
13   public static final String SEVEN = "�?/span>";
14   public static final String EIGHT = "�?/span>";
15   public static final String NINE = "�?/span>";
16   public static final String TEN = "�?/span>";
17   public static final String HUNDRED = "�?/span>";
18   public static final String THOUSAND = "�?/span>";
19   public static final String TEN_THOUSAND = "�?/span>";
20   public static final String HUNDRED_MILLION = "�?/span>";
21   public static final String YUAN = "�?/span>";
22   public static final String JIAO = "�?/span>";
23   public static final String FEN = "�?/span>";
24   public static final String DOT = ".";
25
26   private static SimpleMoneyFormat formatter = null;
27   private HashMap chineseNumberMap = new HashMap();
28   private HashMap chineseMoneyPattern = new HashMap();
29   private NumberFormat numberFormat = NumberFormat.getInstance ();
30
31   private SimpleMoneyFormat() {
32     numberFormat.setMaximumFractionDigits(4);
33     numberFormat.setMinimumFractionDigits(2);
34     numberFormat.setGroupingUsed(false);
35
36     chineseNumberMap.put("0", ZERO);
37     chineseNumberMap.put("1", ONE);
38     chineseNumberMap.put("2", TWO);
39     chineseNumberMap.put("3", THREE);
40     chineseNumberMap.put("4", FOUR);
41     chineseNumberMap.put("5", FIVE);
42     chineseNumberMap.put("6", SIX);
43     chineseNumberMap.put("7", SEVEN);
44     chineseNumberMap.put("8", EIGHT);
45     chineseNumberMap.put("9", NINE);
46     chineseNumberMap.put(DOT, DOT);
47
48     chineseMoneyPattern.put("1", TEN);
49     chineseMoneyPattern.put("2", HUNDRED);
50     chineseMoneyPattern.put("3", THOUSAND);
51     chineseMoneyPattern.put("4", TEN_THOUSAND);
52     chineseMoneyPattern.put("5", TEN);
53     chineseMoneyPattern.put("6", HUNDRED);
54     chineseMoneyPattern.put("7", THOUSAND);
55     chineseMoneyPattern.put("8", HUNDRED_MILLION);
56   }
57
58   public static SimpleMoneyFormat getInstance() {
59     if (formatter == null)
60       formatter = new SimpleMoneyFormat();
61     return formatter;
62   }
63
64   public String format(String moneyStr) {
65     checkPrecision(moneyStr);
66     String result;
67     result = convertToChineseNumber(moneyStr);
68     result = addUnitsToChineseMoneyString(result);
69     return result;
70   }
71
72   public String format(double moneyDouble) {
73     return format(numberFormat.format(moneyDouble));
74   }
75
76   public String format(int moneyInt) {
77     return format(numberFormat.format(moneyInt));
78   }
79
80   public String format(long moneyLong) {
81     return format(numberFormat.format(moneyLong));
82   }
83
84   public String format(Number moneyNum) {
85     return format(numberFormat.format(moneyNum));
86   }
87
88   private String convertToChineseNumber(String moneyStr) {
89     String result;
90     StringBuffer cMoneyStringBuffer = new StringBuffer();
91     for (int i = 0; i < moneyStr.length(); i++) {
92       cMoneyStringBuffer.append (chineseNumberMap.get(moneyStr.substring(i, i + 1)));
93     }
94     //拾䘪仟万亿等都是汉字里面才有的单位，加上它们
95     int indexOfDot = cMoneyStringBuffer.indexOf(DOT);
96     int moneyPatternCursor = 1;
97     for (int i = indexOfDot - 1; i > 0; i--) {
98       cMoneyStringBuffer.insert(i, chineseMoneyPattern.get(EMPTY + moneyPatternCursor));
99       moneyPatternCursor = moneyPatternCursor == 8 ? 1 : moneyPatternCursor + 1;
100     }
101
102     String fractionPart = cMoneyStringBuffer.substring(cMoneyStringBuffer.indexOf("."));
103     cMoneyStringBuffer.delete(cMoneyStringBuffer.indexOf("."), cMoneyStringBuffer.length());
104     while ( cMoneyStringBuffer.indexOf("零拾") != -1) {
105       cMoneyStringBuffer.replace(cMoneyStringBuffer.indexOf("零拾"), cMoneyStringBuffer.indexOf("零拾") + 2, ZERO);
106     }
107     while (cMoneyStringBuffer.indexOf ("零䘪") != -1) {
108       cMoneyStringBuffer.replace(cMoneyStringBuffer.indexOf("零䘪"), cMoneyStringBuffer.indexOf("零䘪") + 2, ZERO);
109     }
110     while (cMoneyStringBuffer.indexOf("零仟") != -1) {
111       cMoneyStringBuffer.replace(cMoneyStringBuffer.indexOf("零仟"), cMoneyStringBuffer.indexOf("零仟") + 2, ZERO);
112     }
113     while (cMoneyStringBuffer.indexOf("零万") != -1) {
114       cMoneyStringBuffer.replace (cMoneyStringBuffer.indexOf("零万"), cMoneyStringBuffer.indexOf("零万") + 2, TEN_THOUSAND);
115     }
116     while (cMoneyStringBuffer.indexOf("零亿") != -1) {
117       cMoneyStringBuffer.replace( cMoneyStringBuffer.indexOf ("零亿"), cMoneyStringBuffer.indexOf("零亿") + 2, HUNDRED_MILLION);
118     }
119     while (cMoneyStringBuffer.indexOf("雉��") != -1) {
120       cMoneyStringBuffer.replace(cMoneyStringBuffer.indexOf ("雉��"), cMoneyStringBuffer.indexOf("雉��") + 2, ZERO);
121     }
122     if (cMoneyStringBuffer.lastIndexOf(ZERO) == cMoneyStringBuffer.length() - 1)
123       cMoneyStringBuffer.delete(cMoneyStringBuffer.length () - 1, cMoneyStringBuffer.length());
124     cMoneyStringBuffer.append(fractionPart);
125
126     result = cMoneyStringBuffer.toString();
127     return result;
128   }
129
130
131   private String addUnitsToChineseMoneyString(String moneyStr) {
132     String result;
133     StringBuffer cMoneyStringBuffer = new StringBuffer(moneyStr);
134     int indexOfDot = cMoneyStringBuffer.indexOf(DOT);
135     cMoneyStringBuffer.replace(indexOfDot, indexOfDot + 1, YUAN);

Yixuan Huang 2006-07-23 23:28 发表评论

blogjava是否可以从邮��发表日志？

Yixuan Huang — Fri, 31 Mar 2006 06:15:00 GMT

请高手指教！
不曾看到有这个设�|�阿�Q?br />不知道可以不�Q?/p>

Yixuan Huang 2006-03-31 14:15 发表评论

选择好了(ji��n)�Q�就勇往直前吧！

Yixuan Huang — Fri, 31 Mar 2006 05:26:00 GMT

��浑噩噩的过�?ji��n)这许多的日子，不断受到打击�Q�打��d��l�而自信心(j��)丧失�?br />一直不��N��拾�?br /> 最怕的��是别�h说自己只说不做，我也努力克服。但自己一直的坏习(f��n)惯，
一时也难以改过来！
现在好了(ji��n)�Q�似乎也�l�自己定�?ji��n)个位。现在的情况�Q�学�?f��n)英语当是比较好�?br />选择�Q�但是技术也不可荒废�?ji��n)，毕竟靠这个吃饭�?br /> 同时也对开源的软�g怀有一丝情感，不会(x��)��此攑ּ��Q�需要让自己充满热情�?br />

Yixuan Huang 2006-03-31 13:26 发表评论

亚洲第一第二第三第四第五第六,国产亚洲综合视频,亚洲免费视频网站

善用 SELECT INTO 功能 zz

code

blogjava是否可以从邮���发表日志？

选择好了(ji��n)�Q�就勇往直前吧！

blogjava是否可以从邮��发表日志？