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 |
|
hirani_prashant
Yak Posting Veteran
93 Posts |
 Posted - 2008-09-23 : 07:28:19
|
| Hello all,i do have to return one single column [namw] value from table [emp]. can you tell me what type of function should i have to use? i mean whether i have to go for scalar value function or say table value function will be best..Prashant |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-23 : 07:35:38
|
| you've a single value or resultset. single column doesnot inply you will have a single value.If its single value use scalar else use table valued function. |
 |
|
|
sunil
Constraint Violating Yak Guru
282 Posts |
Posted - 2008-09-23 : 07:37:10
|
| If you want multiple rows to be returned, use table value function.If you want scalar,like, only return single name from column[name], then, use scalar function. |
|
|
|
|
|
|
which one is better??