nembel / apps / spargs
app name
SQL: SP args → set & condition
command
/spargs
description
(EXPERIMENTAL) Convert SQL code: change stored procedure arguments into SET statements, and conditionals.

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

EXAMPLE:

EXECUTE someproc @varI = 5, @varB = 1, @varC = 'abc'

BECOMES:

SET @varI = 5
SET @varB = 1
SET @varC = 'abc'

AND varI = 5
AND varB = 1
AND varC = 'abc'

RELATED: /spvars
how to use this app

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

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

Option 3: Install this bookmarklet: /spargs

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/