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

Format SQL fails with CREATE VIEW query

I tried SQL Prompt 4.0.3.12 on SQL Server Management Studio 2008.
I found that "Format SQL" function does not work properly for "CREATE VIEW" query
Please, try to Format the following query and you will find this problem. 
CREATE VIEW NEWEMP AS SELECT ENAME, DEPTNO FROM EMP;
latecode
0

Comments

2 comments

Sort by
  • Anu D
    Many thanks for your post.

    I am pleased to inform you that we have fixed the SQL Prompt issue you were experiencing in our latest patch.

    Kindly check the forum post to download the version: https://www.red-gate.com/messageboard/v ... hp?t=10248

    Please let us know if this fixes your issue.
    Anu D
    0
  • latecode
    latest patch works~
    latecode
    0

Add comment

Please sign in to leave a comment.