sql server programming: sp_executedsql and @@NETSLEVEL -- sql server programming

RE: sp_executedsql and @@NETSLEVEL

Alejandro Mesa
3/23/2005 12:51:11 PM

sql server programming:

It seems that sp_executesql call another procedure to execute the batch, so
'select @@nestlevel' is being executed by the second one.

Example:

exec('select @@nestlevel')
execute sp_executesql N'select @@nestlevel'
go

AMB

[quoted text, click to view]

sp_executedsql and @@NETSLEVEL

Jean-Nicolas BERGER
3/23/2005 9:17:56 PM

Could someone explain me the second answer of this query :

select @@nestlevel
go
sp_executesql N'select @@nestlevel'
go

-----------
0

-----------
2

I expected 0 and 1 ...

Thx.
JN.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server programming group.