如何查询链接的SQL Server数据库？ [英] How to query linked SQL server database ?

问题描述

大家好，



我有两台与局域网连接的机器，我在两台机器上都安装了SQL-2008，并且我使用了两台SQL服务器这个存储过程

  Exec  sp_addlinkedserver 
  @ servername  = '  CMSSERVER \SQLEXPRESS'，
 @srvproduct = '  SQLServer OLEDB Provider'，
 @ provider = '  SQLOLEDB'，
 @ datasrc = '  CMS_Syllabus' 

现在我需要查询此服务器数据库，另一台机器。

我写了这个



从CMSSERVER \SQLEXPRESS.CMS_Syllabus.dbo.Admin_Details中选择*



bu我得到的错误是'\'附近的语法不正确



请告诉我我正确地做了这个，或者给我一些其他想法来实现这个。



我需要从我拥有的其他链接服务器上解除查询，请解释我如何制作它...



真的很高兴..



提前致谢。

问候，

Krunal Panchal

解决方案

试试这个

从[CMSSERVER \SQLEXPRESS]中选择* .CMS_Syllabus.dbo.Admin_Details

也许使用openquery可以提供帮助。



http://www.techrepublic.com/blog/datacenter/how-do-i-query-foreign-data-using-sql- servers-linked-servers / 133 [ ^ ]



http://www.ehow.com/how_5164820_query-linked-servers.html [ ^ ]

如果你正在使用链接服务器，你应该尝试OPENQUERY

 选择 * 来自  OPENQUERY （[CMSSERVER \ SQLEXPRESS]，' 从CMS_Syllabus.dbo中选择* .Admin_Details' ）

Hello everyone,

I have two machines which are connected with LAN and i have SQL-2008 on both machine and i have linked both the SQL server by using this stored procedure

Exec sp_addlinkedserver
@servername = 'CMSSERVER\SQLEXPRESS',
@srvproduct='SQLServer OLEDB Provider',
@provider='SQLOLEDB',
@datasrc='CMS_Syllabus'

now i need to query this server database, from another machine.
I have written this

select * from CMSSERVER\SQLEXPRESS.CMS_Syllabus.dbo.Admin_Details

but the error i am getting is incorrect syntax near '\'

Please tell me am i doing this correctly , or give me some other idea to implement this.

I need to fire query on other linked server from the one which i have, please explain me how to make it..

Really stucked up..

Thanks in advance.
Regards,
Krunal Panchal

解决方案

Try this
select * from [CMSSERVER\SQLEXPRESS].CMS_Syllabus.dbo.Admin_Details

Maybe using openquery can help.

http://www.techrepublic.com/blog/datacenter/how-do-i-query-foreign-data-using-sql-servers-linked-servers/133[^]

http://www.ehow.com/how_5164820_query-linked-servers.html[^]

You should try OPENQUERY if you're workin with linked servers

select * from OPENQUERY([CMSSERVER\SQLEXPRESS], 'select * from CMS_Syllabus.dbo.Admin_Details')

这篇关于如何查询链接的SQL Server数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！