由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - SQL Server OpenQuery 问题
相关主题
how to register SQL Server in intranetSQL Server stupid questions
Any SSIS high hand here?Question
什么也不懂,要考个SQL Server 的证what is Microsoft SQL server 's version number?
journal for sql serverSQL Server 2000: When?
请问Enterprise level experienceOne question on SQL Server
shutdown 200+ SQL SERVERS in 45 minuteshow to particially delete record in sql server
Re: A question for SQL ServerSQL Server restore(transferred from other DB) error... HELP!
SQL server 和SQL anywhere的区别是什么?help: SQL Server数据同步复制
相关话题的讨论汇总
话题: openquery话题: sql话题: server话题: chang话题: male
进入Database版参与讨论
1 (共1页)
r***i
发帖数: 112
1
那位高手知道,有两个SQL Server,下面哪个Performance好点:
1. update OpenQuery(LinkedServerName, 'select name from customer
where age = 10 and sex = ''Male''')
set name = 'Chang'
2. update LinkedServerName.DBName.dbo.customer
set name = 'Chang'
where age = 10 and sex = 'Male'
多谢
1 (共1页)
进入Database版参与讨论
相关主题
help: SQL Server数据同步复制请问Enterprise level experience
[转载] SQL Server 2000shutdown 200+ SQL SERVERS in 45 minutes
Can I install MS SQL server on win2k?Re: A question for SQL Server
可不可以用asp把Server上的数据另存到本地SQL server 和SQL anywhere的区别是什么?
how to register SQL Server in intranetSQL Server stupid questions
Any SSIS high hand here?Question
什么也不懂,要考个SQL Server 的证what is Microsoft SQL server 's version number?
journal for sql serverSQL Server 2000: When?
相关话题的讨论汇总
话题: openquery话题: sql话题: server话题: chang话题: male