Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt: Qualify object names

Categories

JUMP TO ANOTHER FORUM

(thinking…)

try_cast

Hi support,

Please add TRY_CAST to you list of key words in SQL Prompt.

Best regards,

Henrik

Henrik Staun Poulsen

Vestas Data Center

Vestas Technology R&D

1 vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Henrik Staun Poulsen shared this idea  ·   ·  Report…  ·  Admin →
declined  ·  Aaron Law responded  · 

Hi Henrik,

Unfortunately the script syntax highlighting is not handled by SQL Prompt. It’s something that’s built into SSMS and so we don’t have control over which keywords get marked as pink.

Show previous admin responses (1)

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Henrik Staun Poulsen commented  ·   ·  Report

    hi Aaron,
    Yes that is very unfortunate, as it is possible to get Redgate to fix things, but Microsoft...
    I'm tired already.

    Best regards,
    Henrik

  • Henrik Staun Poulsen commented  ·   ·  Report

    hi Aaron,
    yes, but it is written in Black, not pink like other functions, like Round()
    try typing
    SELECT TRY_CAST(GETDATE() AS DATETIME)
    SELECT ROUND(1.5 ,0)
    in SSMS