A tool for getting rid of SQLServer chores

Declaration variables and setting initial value in SQLServer is boring chore. To circumvent that I’ve developed a script. Just define your variables then assing the which value you want then get result and copy-paste it to SQLServer

var=c("var1","var2","var3")
val=c(0,1,2)
sqlvars=data.frame(vars,vals)
edit(sqlvars)

i=1
declarations=""
setvals=""
while(i<=nrow(sqlvars)){
  var=sqlvars[i,1]
  val=sqlvars[i,2]
  dec=sprintf("declare @%s float\n",var)
  set=sprintf("set @%s=%s\n",var,val)
  declarations=paste(declarations,dec,sep="")
  setvals=paste(setvals,set,sep="")
  
  i=i+1
}
cat(declarations,"\n",setvals)

declare @var1 float
declare @var2 float
declare @var3 float
 
 set @var1=0
set @var2=1
set @var3=2