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 |
|
rjhe22
Constraint Violating Yak Guru
283 Posts |
 Posted - 2010-02-23 : 12:14:40
|
| can u select * FROM A UDF FUNCTION |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-23 : 12:19:45
|
| yup. provided the UDF function is of table valued type i.e returns a table------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
rjhe22
Constraint Violating Yak Guru
283 Posts |
Posted - 2010-02-23 : 12:21:16
|
| its a scalar one.any way to select from that one |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-23 : 12:24:36
|
yup. just select like a scalar value (select 1)SELECT dbo.yourfunction(paramvalu1,paramvalue2,...) ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
rjhe22
Constraint Violating Yak Guru
283 Posts |
Posted - 2010-02-23 : 12:25:08
|
| wil try that thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-23 : 12:29:57
|
| welcomelets us know how you got on------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
rjhe22
Constraint Violating Yak Guru
283 Posts |
Posted - 2010-02-23 : 12:30:42
|
| that worked again thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-23 : 12:33:23
|
| coolcheers------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
udf function