Options

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.
· Share on Twitter

Comments

  • 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.
    · Share on Twitter
  • Options
    wsorannowsoranno Posts: 65
    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.

    Thanks
    Bill
    Thanks
    Bill Soranno
    MCP, MCTS, MCITP DBA
    Database Administrator
    Winona State University
    Maxwell 143
    wsoranno@winona.edu

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