sql - Why does Exec() run the command in parallel? -
i'm trying understand why #1 executes statements in parallel, #2 executes them 1 1 unless open query window each of them in smss. can enlighten me?
#1 exec(xp_cmdshell.... blah); exec(xp_cmdshell.... blah); #2 select .... xyz; select ..... abc;
#1 should not running in parallel. bol says
xp_cmdshell operates synchronously. command not returned caller until command-shell command completed.
http://msdn.microsoft.com/en-us/library/ms175046.aspx
sql sql-server tsql sql-server-2012
No comments:
Post a Comment