Skip to content

Settings and activity

2 results found

  1. 4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Ed White supported this idea  · 
    An error occurred while saving the comment
    Ed White commented  · 

    I use that script a lot.

    An annoyance in SQL Prompt is that when I type OBJECT_ID and click on the pulldown prompt suggestion for OBJECT_ID, SQL Prompt inserts brackets [ ] around it, resulting in [OBJECT_ID] (I have to option turned on to automatically put brackets around column names). The resulting script
    IF ([OBJECT_ID]('MyTable') IS NOT NULL) DROP TABLE MyTable`
    gives an error--you can't have brackets around OBJECT_ID. So every time I type this, I have to either manually type the entire word OBJECT_ID, or manually remove the brackets.

  2. 15 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  SQL Prompt » Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Ed White supported this idea  · 
    An error occurred while saving the comment
    Ed White commented  · 

    In addition, in SSMS, whenever 'Refresh Suggestions' is selected, also perfom Edit->Intellisense->Refresh Local Cache automatically.