706 results found

1. convert SQL to a vbb (or c#) string statement

   in toad you can get it to convert a SQL statement into a VB or C# statement. i.e. if you have
   select * from atable
   where a = 'FREE'

   this would be converted to
   SQL = "select * from atable"
   sql =sql & "where a = 'FREE'"

   this is then pasted into the clipboard

   it can also do the reverse, have a chunk of VB code with a SQL statement, past it into the window, highlight it and it will try and convert it back to straight SQL (do not worry about variables added into the the vbcode, even toad cannot perform miracles) I used to use this a LOT!

   in toad you can get it to convert a SQL statement into a VB or C# statement. i.e. if you have
   select * from atable
   where a = 'FREE'

   this would be converted to
   SQL = "select * from atable"
   sql =sql & "where a = 'FREE'"

   this is then pasted into the clipboard

   it can also do the reverse, have a chunk of VB code with a SQL statement, past it into the window, highlight it and it will try and convert it back to straight SQL (do not worry about variables added into the the vbcode, even toad… more

   8 votes

   Vote Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

2. Generate Insert statements from resultsets, tables or database
   11 votes

   Vote Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   2 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

3. Change quote completion behavior within Openquery or dynamic SQL strings

   I really like auto quote completion, but when I am working with an openquery statement or dynamic sql where I am having to escape quotes by doubling them up, I find myself fighting the "helpful" behavior of quote completion either refusing to add a second quote or it adds too many quotes.
   So, my suggestion is that the quote completion feature check to see if you are trying to add quotes within a quoted string and change its behavior to either not do quote completion or to (even better) automatically add escaped quotes.

   To illustrate the problem and my proposed solution:
   I am starting a statement like this:
   SELECT HOUSEKEY
   ,ESTIMATEDHOUSEHOLDINCOME
   ,SITEID
   FROM OPENQUERY(unica, '
   Select HOUSEKEY, ESTIMATEDHOUSEHOLDINCOME, SITEID
   from cm.householddemographics hd
   where SITEID in(

   At this point I need to enter a list of values separated by quotes and commas. Because this inside a string, I need to enter a pair of single quotes for at the start and end of every value, but when I type the second single quote, it gives me two, so now I have three single quotes when I was trying to get two.

   Ideally, SQL Prompt would see that I was inside string at this point and either turn off the completion so that when I type two single quotes , I get only two single quoutes, or even better it would always give me a pair of single quotes when I type one (though this could be a problem too, if not handled well).

   Hope that explanation makes sense.

   I really like auto quote completion, but when I am working with an openquery statement or dynamic sql where I am having to escape quotes by doubling them up, I find myself fighting the "helpful" behavior of quote completion either refusing to add a second quote or it adds too many quotes.
   So, my suggestion is that the quote completion feature check to see if you are trying to add quotes within a quoted string and change its behavior to either not do quote completion or to (even better) automatically add escaped quotes.

   To illustrate the problem and my proposed… more

   4 votes

   Vote Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Intellisense  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

4. Format pasted-in list

   I need a way to format a group of text items into a SQL query that I'm going to use for an "IN ('item1','item2','item3')" clause within the WHERE clause. There's got to be a simpler way than manually keying in all the single quotes and commas, particularly when the comma triggers SQL Prompt to start trying to prompt each time, so I have to add an Esc keypress to get SQL Prompt out of the way.

   7 votes

   Vote Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   3 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

5. Place space before END when collapsing shorter case statements

   When collapsing CASE expressions shorter then XXX, the END has no space if there is a preceding parenthesis.

   Example1 = CASE t1.Col004 WHEN 1 THEN t1.Col006 END,
   Example1 = CASE t1.Col004 WHEN 1 THEN TRY_CONVERT(int, t1.Col006)END,

   0 votes

   Vote Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Format SQL  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

6. Add support for SSMS preview candidates

   Some people uses the latest versions of SSMS. I'd like to see it in non-release versions, maybe not fully supported yet.

   0 votes

   Vote Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating