Multiple procedures in one procedure

[litton1]

Is it possible to have multiple stored procedures housed in one procedure, for example, let us say we have a procedure named Company, is there a way to put my Insert, Update, Delete and Select in that procedure so I can then go dbo.Company.Insert or dbo.Company.Update. I think this would greatly reduce the number of procedures needed as we are getting a bit like cannot find wood for trees!

Thx in advance Litton.

Age is a consequence of experience

 

[earthandfire]

I don't think so, but you could pass the action in as a parameter.


Hope this helps.

 

[litton1]

ok thx, I was hoping that i could bulk some together and then point a strongly typed Dataset to them with dbo.Company.Update, but maybe its not possible.

Age is a consequence of experience