What are the challenges you face when working across database platforms? Take the survey
Options

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

  • Options
    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: support@red-gate.com
  • Options
    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: support@red-gate.com
Sign In or Register to comment.