In SQL 2014.
Is there a maximum of time we can exec a dynamic SQL command inside a stored procedure?
In my stored procedure, I have 12. It runs the firts 11 ones and then it seems to hang at the 12th.
Manually I run the 12th query and it works fine. So it is not a syntax error in the string.
SET @strSQL = 'bla bla bla'
If (@@Rowcount > 0)