exec %% what is this ??

Question

Post reply

exec %% what is this ??

Jayanth Kurup

SSC Eights!

Points: 829
More actions
September 14, 2010 at 11:47 am

#142692

Hi
There are a few system procedures in which i found the following exec statement
EXEC %%ScalarType(ID = @xusertype).SetName(Name = @newname)
Does anyone know what the %% after the exec is used for ?
Thanks
J

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Adiga One Orange Chip Points: 27284 More actions · Answer 1

It is an internal procedure call. Most likely associated with sys.sp_rename. Refer this

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Jayanth Kurup SSC Eights! Points: 829 More actions · Answer 2

Yes , i saw the usage in sp_rename however I wanted to know the difference between a simple EXEC vs a EXEC %%

Suresh B. SSC-Insane Points: 22986 More actions · Answer 3

Are you thinking that EXEC %% is a different command? It's not. It's the same EXEC.

What is different is %%xxx. These are undocumented and meant for internal use by Microsoft.

Jayanth Kurup SSC Eights! Points: 829 More actions · Answer 4

Hi

I am sure they are undocumented commands however i feel the usage is not the same as the exec statement used in Procedure calls. infact if u look at the command in sp_rename you will see the parameter input resembles something u wud see in C# coding than SQL.