What are the challenges you face when working across database platforms? Take the survey

Typing while inside single quotes

BrianFinkelBrianFinkel Posts: 33
edited November 6, 2007 3:56PM in SQL Prompt Previous Versions
Tell me if there's something I'm missing here, but shouldn't SQL Prompt ignore input while the cursor is in between single-quote chars (because that means you're entering a literal string and not a SQL statement)?
Using Sql Prompt 3.7 with SQL Server 2000, Query Analyzer, and 2005 Mgmt Studio.


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    I don't think SQL Prompt does this -- do you have an example? I've tried it with sp_executesql and it doesn't suggest candidates from inside a string.
  • Options
    I have found that SQL Prompt will work sometimes from within single quotes, but it is not always as reliable.
    I do a lot of work with OPENQUERY and what is in the quotes is an sql statement.
    To get it to prompt, I have to manually activate with Ctrl+Space.
    The problem I have is the snippets do not show. I have to click on the snippet icon to see them (not that big a deal).

    I would like to see an option to control when to ignore single quotes. That way, those that want the prompting can use it.

    Bill Soranno
    Database Administrator
    Winona State University
    Maxwell 143

    "Quality, like Success, is a Journey, not a Destination" - William Soranno '92
Sign In or Register to comment.