Skip to content

gerneio/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.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

About

Convert sp_executesql to sql

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages

  • TypeScript 100.0%