Sunday, 15 May 2011

sql - Why does Exec() run the command in parallel? -



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