Visual Studio扩展以执行sql [英] visual studio extension to execute sql

问题描述

我的Visual Studio 2010项目中有几个.sql文件.

I have several .sql files in my visual studio 2010 project.

我正在寻找扩展名或添加我可以在sql文件上单击鼠标右键并在sql服务器数据库上执行其内容的位置.

I am looking for an extension or add on where I can right click on the sql file and execute its contents against a sql server database.

有人知道这样的扩展名存在吗?

Anyone know if such an extension exists?

推荐答案

从SQL Server Denali(至少在我安装的社区预览版本中开始)开始，SQL Management Studio已集成到Visual Studio 2010 IDE中.因此，您可以从VS2010中获得所有语法高亮显示，对象资源管理器等.

Starting with SQL Server Denali (at least in the community preview version I installed to play with), SQL Management Studio is integrated into the Visual Studio 2010 IDE. So you get all the syntax highlighting, Object Explorer, etc., all from within VS2010.

也就是说，我没有特别尝试将SQL脚本添加到现有项目中(由于存在问题，我上周卸载了共享功能)，但是由于集成紧密，我想可以做更多或更少的是您想要的.

That said, I didn't specifically try adding a SQL script to an existing project (and I uninstalled the shared features last week because there were... issues), but with such a tight integration, I assume doing more or less what you're asking for is the intention.

这篇关于Visual Studio扩展以执行sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！