[Message Deleted]
-
[Message Deleted]
-
[Message Deleted]
That depends how you mean. Do you want to call a proc which creates another proc ? You can do that, but why ?
Christian Graus - C++ MVP
-
That depends how you mean. Do you want to call a proc which creates another proc ? You can do that, but why ?
Christian Graus - C++ MVP
[Message Deleted]
-
[Message Deleted]
I suspect you will have to build the string for the new proc then execute it.
Something like this DECLARE @NewProc varchar(1000) SET @NewProc = 'Create Proc MyNewProc AS select * from Address go' exec (@NewProc) exec ('MyNewProc')
Blog Have I http:\\www.frankkerrigan.com
-
[Message Deleted]
yes yes
--EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters
-
[Message Deleted]
Then why on earth are you asking them here ?
Christian Graus - C++ MVP
-
Then why on earth are you asking them here ?
Christian Graus - C++ MVP
Christian Graus wrote:
Then why on earth are you asking them here ?
:omg: Doesn't sound like interview went too well for the OP? Or perhaps the OP is looking for assurance that the questions were answered correctly :)