如何阻止Visual Studio报表服务更改我的SQL语句 [英] How do I stop Visual Studio Report Services from changing my SQL Statements

问题描述

当我在Visual Studio中输入SQL状态时，它会自动更改语句的格式。它还会更改SQL，使它们不再执行。

When I enter a SQL statemnent in Visual Studio, it automatically changes the formatting of the statements. It also changes the SQLs such that they no longer execute.

推荐答案

我有同样的问题，这是错误的论坛吗？  ;两年多没有人回答。

I have the same problem, is this the wrong forum?  No one has answered in over two years.

我回来了？ 我使用的是Visual Studio 2010，我从Oracle加载了ODTwithODAC1120320_32bit。 

I'm back with an answer?  I am using Visual Studio 2010, I loaded ODTwithODAC1120320_32bit from Oracle. 

如果在服务器资源管理器中右键单击数据库连接中的大多数位置，则菜单项"新查询"为您提供Microsoft Query Designer。 我在Oracle连接下右键单击了Synonyms文件夹，得到了"Query
Window"。菜单项。 这个窗口的格式看起来好像有点像Oracle SQL Developer，并且没有改变查询，所以它不起作用。

If you right-click in most places in the database connection in the Server Explorer, the menu item "New Query" gives you the Microsoft Query Designer.  I right-clicked on the Synonyms folder under my Oracle connection and got the "Query Window" menu item.  This window's formatting looks and seems to behave a bit like the Oracle SQL Developer and did not alter the query so that it would not work.

我也看到了"查询窗口"。菜单项位于"数据"上。下拉菜单。

I also see that the "Query Window" menu item is on the "Data" pull-down menu.

这篇关于如何阻止Visual Studio报表服务更改我的SQL语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！