The SET lost param name

[hiowenluke]

Hi Pejman,

Source:

exec sp_executesql N'update mytable set field=@P1',N'@P1 varchar(10)', 'value'

After converted:

DECLARE @P1 varchar(10)
SET 'value' --<<-- error

update mytable set field=@P1

Please fix it, thanks.

Best,
Owen

[PejmanNik]

Hi @hiowenluke
Thank you for using this extension 🤞
This has happened due to your query parameters value. They are unnamed unlike what I was always seeing.

Fixed in v 0.0.2

[hiowenluke]

Hi Pejman, Thanks a lot. Best Owen

…

On Wed, Dec 19, 2018 at 4:23 AM Pejman ***@***.***> wrote: Hi @hiowenluke <https://github.com/hiowenluke> Thank you for using this extension 🤞 This has happened due to your query parameters value are unnamed unlike what I was always seeing. Fixed in v 0.0.2 — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#1 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AS88PE73NIADWGFhMJu9buxZCKV8IddXks5u6U68gaJpZM4ZXixm> .