Skip to content

PejmanNik/sqlops-spexecutesql-to-sql

Repository files navigation

Convert sp_executesql to sql

This extension can be helpful in debugging SQL query executed by your application (e.g some of ORM like EF)

Features

press F1 and type Convert command to run convertor on active query.

gif

Installation

The current release is available to download as a .vsix file and can be installed by opening the command palette (ctrl/command+shift+p) and selecting Extensions: Install from VSIX...

Thanks to

Inspiring from https://github.com/mattwoberts/execsqlformat. so Thank you @mattwoberts.

Release Notes

[1.0.3] - 2020-06-29 - @gerneio

Enhancement

  • Support converting multiple sp_executesql statements #6

[1.0.2] - 2020-01-04

Fixed

  • fix bug in parsing double quote in the query

[1.0.1] - 2019-09-07

Fixed

  • fix bug in regex for reading query with extra white character

[1.0.0] - 2019-06-30

Fixed

  • fix a bug in format document
  • improve the experience with modify selection and scrolls position

[0.0.2] - 2018-12-18

Fixed

  • fix bug in sp_executesql with an unnamed parameter value

[0.0.1] - 2018-11-13

  • Initial release