Capture

Declaration variables and setting the initial value in SQLServer is a boring chore. Especially when there are a lot of variables you should write 2 times more code.

To circumvent that I’ve developed a script. Just define your variables then assign the which value you want then get result and copy-paste it to SQLServer

Here is how:

http://rpubs.com/suatatan/sqlserver-declarator