insert into std(a000,a001,a100,a101,a102,a200,a205,a206,a207,a209,a210,convert(ntext(16),a298),a300,convert(ntext(16),a301),
convert(ntext(16),a302),a305,a309,a404,a409,convert(ntext(16),a461),convert(ntext(16),a462),convert(ntext(16),a502),
convert(ntext(16),a800),convert(ntext(16),a824),a825,a826,convert(ntext(16),a838),a842,a845,a846,a847,a850,a885)
(select a000,a001,a100,a101,a102,a200,a205,a206,a207,a209,a210,a298,a300,a301,a302,a305,
a309,a404,a409,a461,a462,a502,a800,a824,a825,a826,a838,a842,a845,a846,a847,a850,a885 from tempstd)
求大神赐教!!~
|