如何在没有Microsoft SQL Server的情况下查询MS Sql Server数据库？ [英] How to query a MS Sql Server DB without Microsoft SQL Server?

问题描述

我在服务器机器上有MS sql server数据库，我想从本地机器访问/查询该数据库，但我没有在本地机器上安装MS SQL SERVER，可能有什么可能的选项我可以查询该数据库？

I have MS sql server database in server machine, i wanted to access/query that db from local mchine but i do not have MS SQL SERVER installed in local machine, what could be the possible options can i have to query that database?

推荐答案

您可以使用 SQLCMD utity来对数据库运行查询。

以下是一些链接 -

http://msdn.microsoft.com/ en-IN / library / ms170572.aspx [ ^ ]

http： //technet.microsoft.com/en-us/library/ms165702(v=sql.105).aspx [ ^ ]

You can use SQLCMD utity to run queries on a database.
Here are some links -
http://msdn.microsoft.com/en-IN/library/ms170572.aspx[^]
http://technet.microsoft.com/en-us/library/ms165702(v=sql.105).aspx[^]

我想你的意思是你没有Sql Server Management Studio ins在当地？有许多应用程序，如Excel和Access，将为您远程查询SQL Server。

I think you mean you don't have Sql Server Management Studio installed locally? There are many applications such as Excel and Access that will query SQL Server remotely for you.

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