B*****g
发帖数: 34098 | 1 想加external data source（txt, excel, odbc, ....), 没找到。谢谢 |
w*******e
发帖数: 1622 | 2 link table? 怎么没听说过这词呢?
【在 B*****g 的大作中提到】
: 想加external data source（txt, excel, odbc, ....), 没找到。谢谢
|
c*****d
发帖数: 6045 | 3 只有Oracle里有external table吧
MS SQL好像没有这个概念
【在 w*******e 的大作中提到】
: link table? 怎么没听说过这词呢?
|
B*****g
发帖数: 34098 | 4 Access has it. So I guess SQL server should have it.
【在 c*****d 的大作中提到】
: 只有Oracle里有external table吧
: MS SQL好像没有这个概念
|
c**t
发帖数: 2744 | 5 SQL server supports linked server, which could be other SQL server or Oracle.
【在 B*****g 的大作中提到】
: Access has it. So I guess SQL server should have it.
|
B*****g
发帖数: 34098 | 6 不support file？nnd，看来还不能uninstall foxpro
Oracle.
【在 c**t 的大作中提到】
: SQL server supports linked server, which could be other SQL server or Oracle.
|
j*****n
发帖数: 1781 | 7 even you can not import/export data via express version.
2k5 needs SSIS to do that... |
B*****g
发帖数: 34098 | 8 nnd，sql server改来改去还是个垃圾。sql server 2008 express有这些个功能吗？
【在 j*****n 的大作中提到】
: even you can not import/export data via express version.
: 2k5 needs SSIS to do that...
|
j*****n
发帖数: 1781 | 9 I doubt...
SSIS uses CLR and gives you more flexibility to do the data integrity,
such as you can use VB.NET language instead of T-SQL... which I think it is
stupid idea //sigh
【在 B*****g 的大作中提到】
: nnd，sql server改来改去还是个垃圾。sql server 2008 express有这些个功能吗？
|
B*****g
发帖数: 34098 | 10 这就是给写vb的人点甜头，C#能用吗？不过最近开始看2005的T-sql，似乎功能挺强。
is
【在 j*****n 的大作中提到】
: I doubt...
: SSIS uses CLR and gives you more flexibility to do the data integrity,
: such as you can use VB.NET language instead of T-SQL... which I think it is
: stupid idea //sigh
|
j*****n
发帖数: 1781 | 11 sounds no C#.
M$ claims that VB.net and C# would be the same performance after compiled,
since they all come to CLR.
I would not use VB to do the SQL anyway, I spend years to get ride of front-
end programing, do not want go back anymore, hehe
【在 B*****g 的大作中提到】
: 这就是给写vb的人点甜头，C#能用吗？不过最近开始看2005的T-sql，似乎功能挺强。
:
: is
|
B*****g
发帖数: 34098 | 12 link server能update oracle那边吗？
front-
强。
【在 j*****n 的大作中提到】
: sounds no C#.
: M$ claims that VB.net and C# would be the same performance after compiled,
: since they all come to CLR.
: I would not use VB to do the SQL anyway, I spend years to get ride of front-
: end programing, do not want go back anymore, hehe
|
c**t
发帖数: 2744 | 13 yes
【在 B*****g 的大作中提到】
: link server能update oracle那边吗？
:
: front-
: 强。
|
B*****g
发帖数: 34098 | 14 谢谢
【在 c**t 的大作中提到】
: yes
|
