关于col8的讨论汇总 - 话题女王

n********6
发帖数: 1511

来自主题: Database版 - Need help to read .xls to SQLServer2005 Through SSIS Wizard

Environment: Win2003, SQL2005,
Process: Load .xls by using SSIS Wizard (DB->Task->Import Data)
.xls File Structure: (col1, col2, ..., col8, col9)
Columns: col8:numbers; col9: numbers
First Line: xx, xx,... xx, xx (to set col8, col9 character)
Loading result:col1, col2, ... col8 (nvarchar), col9(float)
Question: Why col8 nvarchar while col9 float?
Thank you.

h******y
发帖数: 25

来自主题: Database版 - 请问sql 有条件性的select columns

具体例子如下：
select * from table -- gives the following output
server col2 col3 col4 col5 col6 col7 col8 col9 col10
1 1234 null null 678 987 890 null 567 null
1 4565 null null 234 67 56 null 345 null
2 null null 578 567 234 null 73 18 null
2 null null 626 289 395 null 84 399 null
3 567 null 845 null 987 674 null null... 阅读全帖

i*******d
发帖数: 81

来自主题: Database版 - 请问sql 有条件性的select columns

why data appears in pairs? is it always true?
What is the desired output if you have:
server col2 col3 col4 col5 col6 col7 col8 col9 col10
1 1234 null null 678 987 890 null 567 null
1 null null null 234 67 56 null 345 null

null
null
null
648
921

#	版面	帖数(主题数)
-	全站	4871 (796)
1	Military	3777 (569)
2	Stock	341 (51)
3	Joke	117 (17)
4	History	116 (3)
5	Automobile	100 (9)
6	USANews	55 (9)
7	Midlife	45 (1)
8	Headline	41 (41)
9	Dreamer	33 (13)
10	FleaMarket	32 (20)
11	Living	30 (7)

版面

帖数(主题数)

全站

4871 (796)

3777 (569)

341 (51)

117 (17)

116 (3)