Re: Pass Table as a parameter to a function
- From: ArunDhaJ <arundhaj@xxxxxxxxx>
- Date: Thu, 26 Jul 2007 13:35:41 -0000
On Jul 26, 3:20 pm, Paul <paulwragg2...@xxxxxxxxxxx> wrote:
As already suggested a procedure will work. We have a procedure to
drop all default constraints from our tables. I pass in a list of
tables to this procedure (the list of tables are loaded in to a table
variable by calling a function). If you need further help then re-post
and I can hopefully give you an example!
Paul
Hi All,
Thanks for your response.. :)
Ya.. the procedure will do fine....
But my question is that is there any performance difference between
using functions and procedure....
Thanks
ArunDhaJ
.
- Follow-Ups:
- Re: Pass Table as a parameter to a function
- From: Erland Sommarskog
- Re: Pass Table as a parameter to a function
- References:
- Pass Table as a parameter to a function
- From: ArunDhaJ
- Re: Pass Table as a parameter to a function
- From: steve
- Re: Pass Table as a parameter to a function
- From: Paul
- Pass Table as a parameter to a function
- Prev by Date: MS SQL return Min count homeMDB
- Next by Date: Can I manage MSDE with SSMS??
- Previous by thread: Re: Pass Table as a parameter to a function
- Next by thread: Re: Pass Table as a parameter to a function
- Index(es):
Relevant Pages
|