SQL: SP vars → declare & set [web app]

app name

SQL: SP vars → declare & set

command

/spvars

description

(EXPERIMENTAL) Convert SQL code: change variables in the definition of a stored procedure into DECLARE and SET statements.

Use to test/edit code of SQL procedures. Output for MS SQL. TBD: MySQL support.

EXAMPLE:

CREATE PROCEDURE someproc @varB bit = 1, @varC varchar(10) = '' AS

BECOMES:

DECLARE @varB bit, @varC varchar(10)
SET @varB = 1
SET @varC = ''

RELATED: /spargs

how to use this app

Option 1: Click the "try it now button" above.

Option 2: Go to nembel.com and type /spvars

Option 3: Install this bookmarklet: /spvars

Option 4: Install the Nembel toolbar bookmarklet to instantly access hundreds of tools like this on any web page.

about nembel web apps

Nembel web applications are online tools, utilities, and search shortcuts. Each one can be used from the home page, the toolbar, or saved as separate bookmarklets. Our instant online apps can be used without logging in or signing in. No account, no signup, and no registration is required or necessary.

Many can be used directly and instantly on the Nembel home page.

Visit the home page and type keywords to see relevant tools, or browse the list at nembel.com/apps/