Access has it. So I guess SQL server should have it.
【在 c*****d 的大作中提到】 : 只有Oracle里有external table吧 : MS SQL好像没有这个概念
c*t
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
6 楼
不support file?nnd,看来还不能uninstall foxpro
Oracle.
【在 c**t 的大作中提到】 : SQL server supports linked server, which could be other SQL server or Oracle.
j*n
7 楼
even you can not import/export data via express version. 2k5 needs SSIS to do that...
B*g
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
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
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
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
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