Showing posts with label intellisense. Show all posts
Showing posts with label intellisense. Show all posts

Friday, March 9, 2012

Intellisense in Views corrupts SQL Syntax

When selecting "Design mode" from "Views", the syntax I enter is
automatically changed on-the-fly and corrupts the syntax.
For example from pubs:
SELECT TOP 100 PERCENT *
FROM dbo.authors a INNER JOIN
dbo.publishers p ON a.city = p.city
ORDER BY a.au_lname DESC
Problems:
1. I can't remove "TOP 100 PERCENT" which is valid SQL.
2. "a INNER JOIN" should be "AS a INNER JOIN"
So, how can I code valid SQL without the code being changed?
Sparky
and the phrase "a INNER JOIN" should be:
"AS a INNER JOIN"which would be valid
EM has a lot of strange things in the query builder. I recommend developing your views in Query
Analyzer. As for TOP, you can't have ORDER BY without TOP in a view. A view is supposed to behave as
a table and a table is not ordered. A view allow ORDER BY if you have TOP as this will influence
which rows are returned, the ordering is possibly still not guaranteed. You might want to look at
this:
http://www.aspfaq.com/show.asp?id=2455
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sparky" <sparky@.boing.com> wrote in message
news:7F7B6BCF-CD0C-405B-8A11-7AC6E268E80F@.microsoft.com...
> When selecting "Design mode" from "Views", the syntax I enter is
> automatically changed on-the-fly and corrupts the syntax.
> For example from pubs:
> SELECT TOP 100 PERCENT *
> FROM dbo.authors a INNER JOIN
> dbo.publishers p ON a.city = p.city
> ORDER BY a.au_lname DESC
> Problems:
> 1. I can't remove "TOP 100 PERCENT" which is valid SQL.
> 2. "a INNER JOIN" should be "AS a INNER JOIN"
> So, how can I code valid SQL without the code being changed?
> Sparky
> and the phrase "a INNER JOIN" should be:
> "AS a INNER JOIN"which would be valid
|||The problem arises when I use Visual Studio 2003's Server Explorer tool to
explore a selected "View" from the sqlserver's treeview. I was not using EM
or QA to edit the view.
Tibor: Thnaks sooo much for the reply - saw your web site -- Great!
Sparky
================================================
"Sparky" wrote:

> When selecting "Design mode" from "Views", the syntax I enter is
> automatically changed on-the-fly and corrupts the syntax.
> For example from pubs:
> SELECT TOP 100 PERCENT *
> FROM dbo.authors a INNER JOIN
> dbo.publishers p ON a.city = p.city
> ORDER BY a.au_lname DESC
> Problems:
> 1. I can't remove "TOP 100 PERCENT" which is valid SQL.
> 2. "a INNER JOIN" should be "AS a INNER JOIN"
> So, how can I code valid SQL without the code being changed?
> Sparky
> and the phrase "a INNER JOIN" should be:
> "AS a INNER JOIN"which would be valid

Intellisense in QueryAnalzer ??

Was there a beta version of the new 2005 "QueryAnalyer" that came with
Intellisense? Am I just crazy? I thought that there was a beta with this
feature.Hello beginthreadex,

> Was there a beta version of the new 2005 "QueryAnalyer" that came with
> Intellisense? Am I just crazy? I thought that there was a beta with
> this feature.
There was, for a while and it got cut so the product would get out the door.
Give PromptSQL [0] a looksee instead.
[0]: http://www.promptsql.com/
its Beeyotchin.
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||What beta? Was it provided in the MSDN?
We already have several PromptSQL licenses in the office here.

> Hello beginthreadex,
>
> There was, for a while and it got cut so the product would get out the
> door. Give PromptSQL [0] a looksee instead.
> [0]: http://www.promptsql.com/
> its Beeyotchin.
> Thank you,
> Kent Tegels
> DevelopMentor
> http://staff.develop.com/ktegels/
new|||PromptSQL looks interesting since it allows you to use the native Microsoft
tools. In fact I might have to take a look at it. If you are not tied to
the Microsoft tools Aqua Data Studio does a decent job of providing this
functionality as well. http://www.aquafold.com
"Kent Tegels" <ktegels@.develop.com> wrote in message
news:b87ad74b5b98c7b811768ca19e@.news.microsoft.com...
> Hello beginthreadex,
>
> There was, for a while and it got cut so the product would get out the
> door. Give PromptSQL [0] a looksee instead.
> [0]: http://www.promptsql.com/
> its Beeyotchin.
> Thank you,
> Kent Tegels
> DevelopMentor
> http://staff.develop.com/ktegels/
>|||Hello beginthreadex,
B1 if I recall correctly. Its been ages ago since that though. Like, what
20 months? :)
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/

intellisense for QA?

VB.NET (actually VS.NET) has a feature called Intellisense that will display
methods/properties for an object once you type a dot. For example:
Object1.
At that point, you may see a list similar to:
- Compare
- GetType
- Parse
- ToString
which you can choose. No memorization required. Is there a plug-in or
something for QA that will do the above? For example, I might join two
tables:
select us.column1, mm.column1
from dbo.summary us JOIN
dbo.message mm
ON us.
When I type us., I'd like to see all the fields in that table. Any
suggestions?
Thanks,
Brett> Is there a plug-in or
> something for QA that will do the above?
No. And the feature was dropped from the next version because T-SQL isn't
written and organized in a way that suits intellisense, the way a more
structured programming language is. If you type SELECT you might expect a
drop-down to appear with all of the built-in aggregate functions,
user-defined functions and every single column in all views and tables in
the entire database. The kind of metadata retrieval required for this just
didn't make sense...

> When I type us., I'd like to see all the fields in that table. Any
> suggestions?
Check out some of the other tools written for writing/modifying T-SQL,
though I've never heard of one that accomplishes this. The tools that ship
with SQL Server won't have this feature for a while (if ever)...|||There is no plug in for QA. This feature has also been dropped, currently,
from SQL 2005. I would look for a third party tool for running queries to
solve this problem.
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"Brett" wrote:

> VB.NET (actually VS.NET) has a feature called Intellisense that will displ
ay
> methods/properties for an object once you type a dot. For example:
> Object1.
> At that point, you may see a list similar to:
> - Compare
> - GetType
> - Parse
> - ToString
> which you can choose. No memorization required. Is there a plug-in or
> something for QA that will do the above? For example, I might join two
> tables:
> select us.column1, mm.column1
> from dbo.summary us JOIN
> dbo.message mm
> ON us.
> When I type us., I'd like to see all the fields in that table. Any
> suggestions?
> Thanks,
> Brett
>
>|||Brett wrote:
> VB.NET (actually VS.NET) has a feature called Intellisense that will
> display methods/properties for an object once you type a dot. For
> example:
> Object1.
> At that point, you may see a list similar to:
> - Compare
> - GetType
> - Parse
> - ToString
> which you can choose. No memorization required. Is there a plug-in
> or something for QA that will do the above? For example, I might
> join two tables:
> select us.column1, mm.column1
> from dbo.summary us JOIN
> dbo.message mm
> ON us.
> When I type us., I'd like to see all the fields in that table. Any
> suggestions?
> Thanks,
> Brett
Take a look at SQL IDE from Imceda. We offer autocomplete on objects.
14-day trial from web site.
David Gugick
Imceda Software
www.imceda.com|||Have a look at ApexSQL Edit (http://www.apexsql.com/). I bought this
some time ago and it's a pretty good product. Their support is very good
and you get free upgrades for ever, major and minor versions.
Regards,
William D. Bartholomew
http://blog.bartholomew.id.au
*** Sent via Developersdex http://www.examnotes.net ***|||We've added T-SQL Intellisense-like word-completion support for Visual
Studio 2003/2005 and the SQL Server 2005 Management Studio to our PromptSQL
product. So you can now have auto-completion for TSQL in those environments
and of course Query Analyzer.
SELECT * FROM Em[Ctrl-Space] displays a popup with all tables starting with
Em
SELECT * FROM Employees AS e JOIN [Ctrl-Space] shows a popup with all tables
related to the employees table (via primary/foreign keys)
SELECT * FROM Employees AS E JOIN Orders o on [Ctrl-Space] shows a popup
with possible joins based on primary/foreign keys on the tables in the FROM.
Press "." after a table name to get the columns in the table. It has proper
support for SQL Server 2005, which of course means prefixing table names
with schema names as appropriate.
Online demos and registration-free download: http://www.promptsql.com/
PromptSQL is written in C# and uses hooks to monitor Query Analyzer and the
other supported environments. You carry on using these standard tools.
Regards,
PromptSQL Team.
Brett wrote:
> VB.NET (actually VS.NET) has a feature called Intellisense that will
> display
> methods/properties for an object once you type a dot. For example:
> Object1.
> At that point, you may see a list similar to:
> - Compare
> - GetType
> - Parse
> - ToString
> which you can choose. No memorization required. Is there a plug-in or
> something for QA that will do the above? For example, I might join two
> tables:
> select us.column1, mm.column1
> from dbo.summary us JOIN
> dbo.message mm
> ON us.
> When I type us., I'd like to see all the fields in that table. Any
> suggestions?
> Thanks,
> Brett|||your product is way - however this is not the correct forum for these
types of post. Please post this in microsoft.public.sqlserver.tools.
Truly a fabulous product though.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Damian Mehers" <feedback at promptsql.com> wrote in message
news:O9hBnr1mFHA.3608@.TK2MSFTNGP15.phx.gbl...
> We've added T-SQL Intellisense-like word-completion support for Visual
> Studio 2003/2005 and the SQL Server 2005 Management Studio to our
PromptSQL
> product. So you can now have auto-completion for TSQL in those
environments
> and of course Query Analyzer.
> SELECT * FROM Em[Ctrl-Space] displays a popup with all tables starting
with
> Em
> SELECT * FROM Employees AS e JOIN [Ctrl-Space] shows a popup with all
tables
> related to the employees table (via primary/foreign keys)
> SELECT * FROM Employees AS E JOIN Orders o on [Ctrl-Space] shows a popup
> with possible joins based on primary/foreign keys on the tables in the
FROM.
> Press "." after a table name to get the columns in the table. It has
proper
> support for SQL Server 2005, which of course means prefixing table names
> with schema names as appropriate.
> Online demos and registration-free download: http://www.promptsql.com/
> PromptSQL is written in C# and uses hooks to monitor Query Analyzer and
the
> other supported environments. You carry on using these standard tools.
> Regards,
> PromptSQL Team.
>
>
> Brett wrote:
>

Intellisense for custom assemblies?

SSRS 2005
I am using a custom assembly with my reports.
When I reference my custom assembly using the =Code.<assembly reference>
syntax in the expressions in my report, Intellisense only shows the methods
(that I guess are) associated with the standard System.Object:
Equals
GetHashCode
GetType
ReferenceEquals
ToString
I do not see any of the Public methods defined in my custom assembly.
Is there a way to have that information provided within the Report Designer
when I use the "Edit Expression" dialog box, or is this a limitation in
Report Designer?
-- Chris
--
Chris, SSSIHello Chris,
This issue is a limitation in the Report Desinger. Since when you have put
some custom code in the report, the IDE could not compile and get the
method name immediately. You need to copy the method name to the expression
where you want to use the code.
If you have any concern about this issue, you could send your feedback
directly to the product team:
http://connect.microsoft.com/sqlserver/
Thank you for your understanding!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Wei Lu,
Thank you for your help. That is what I figured...that it is a limitation in
the product. Too bad, since having Intellisense support would be a nice
feature and would be consistent with the rest of the Visual Studio designers.
--
Chris, SSSI
"Wei Lu [MSFT]" wrote:
> Hello Chris,
> This issue is a limitation in the Report Desinger. Since when you have put
> some custom code in the report, the IDE could not compile and get the
> method name immediately. You need to copy the method name to the expression
> where you want to use the code.
> If you have any concern about this issue, you could send your feedback
> directly to the product team:
> http://connect.microsoft.com/sqlserver/
> Thank you for your understanding!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Chris,
I would like to suggest you send your feedback to the product team.
http://connect.microsoft.com/sqlserver/
Thank you for your understanding!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei Lu,
>>I would like to suggest you send your feedback to the product team.
Is there a particular reason that you are not able to do this? I would think
Microsoft would want to proactively collect feedback on its products and not
have to rely on customers finding the time to report enhancement requests or
bugs on their own.
-- Chris
--
Chris, SSSI
"Wei Lu [MSFT]" wrote:
> Hello Chris,
> I would like to suggest you send your feedback to the product team.
> http://connect.microsoft.com/sqlserver/
> Thank you for your understanding!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Chris,
When you send the feedback to the website, our product team will monitor
and consider the request.
I have send the feedback to the product team and they will consider this.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.