feature request

ogrishman

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]

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

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.