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

feature request

Hi friends,

I use sql prompt 4 to help me write an insert statement, it generate the following text:
INSERT INTO dbo.t1
        (c1, c2)
VALUES  ('', -- c1 - varchar(4)
         NULL  -- c2 - nvarchar(4)
         )

Why the nvarchar column have a default NULL value? If it is N'' will be much better. Eg: 
INSERT INTO dbo.t1
        (c1, c2)
VALUES  ('', -- c1 - varchar(4)
         N''  -- c2 - nvarchar(4)
         )

Thanks.[/quote]
ogrishman
0

Comments

2 comments

Sort by
  • Anu D
    Many thanks for your post ogrishman.

    I have logged this issue in our internal tracking system whose tracking id is SP-2952.

    Our developers are looking into this and I will update you as soon as it is fixed.

    Kindly let us know if you have any other issues or questions regarding the product,I'll like to help.
    Anu D
    0
  • Anu D
    Many thanks for your patience regarding this issue.

    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

Add comment

Please sign in to leave a comment.