How can we help you today? How can we help you today?

Typing while inside single quotes

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)?
BrianFinkel
0

Comments

2 comments

Sort by
  • Brian Donahue
    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.
    Brian Donahue
    0
  • wsoranno
    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
    wsoranno
    0

Add comment

Please sign in to leave a comment.