Tuesday, 13 August 2013

SQL Server 2012 Subprocesses

SQL Server 2012 Subprocesses

I have a "If EXISTS" Query in my Code. On the Cases I do a Insert into
Statement with different Values. My idea is, that the Statement runing in
a Subprocess like
goto MySubPro(Value1, Value2)
Sub MySubPro
Insert into ...
End Sub
But i get an Error like: Wrong Syntax near by "Sub" All Information i
found in Web are describe the Select Subprocess, but i will run different
diferent code in the Subprocess and come back to the mainprocess.. Is
there a way to do this?

No comments:

Post a Comment