feature request

ogrishmanogrishman Posts: 81 Bronze 4
edited June 4, 2010 10:33AM in SQL Prompt Previous Versions
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]

Comments

  • Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
  • Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
Sign In or Register to comment.