Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
desikankannan
Posting Yak Master
152 Posts |
 Posted - 2010-02-13 : 13:06:40
|
| Hi,which is best to use user define function or viewretrivew data fasterDesikankannan |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-13 : 13:10:06
|
| that depends on your actual scenario. can you tell what your requirement is?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
desikankannan
Posting Yak Master
152 Posts |
Posted - 2010-02-13 : 13:13:20
|
| i have multiple subquries retreving data from 6 tables, which is the best way now to use view or sql function or sql stored procedureDesikankannan |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-13 : 13:23:08
|
| do you need to make query based on some parameters?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
desikankannan
Posting Yak Master
152 Posts |
Posted - 2010-02-13 : 13:26:26
|
| yesDesikankannan |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-13 : 13:31:40
|
| then you need to go for function or procedure.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-14 : 03:03:57
|
| ... or dynamic SQL |
|
|
|
|
|
|
best to use sql user define function or view