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 |
|
acdacd
Yak Posting Veteran
63 Posts |
 Posted - 2005-07-13 : 01:36:45
|
| How to run the user-defined function?(which return table)eg dbo.csvTovarchar('asp.net, phph, java')Error: incorrect syntac near 'asp.net, phph, java'However, when i use it in other sql, it is fine, Anyway to execute it like stored procbe a hardworking people!! |
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2005-07-13 : 01:55:25
|
Not sure what you mean by "However, when i use it in other sql, it is fine"You invoke a UDF via SELECTSELECT *FROM dbo.csvTovarchar('asp.net, phph, java')AndyBeauty is in the eyes of the beerholder  |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-07-13 : 02:28:44
|
| Do you have problem in calling this query from Front End application?MadhivananFailing to plan is Planning to fail |
|
|
|
acdacd
Yak Posting Veteran
63 Posts |
Posted - 2005-07-13 : 02:39:15
|
| Orginally, i think the user-defined function can be exec like the stored proctherefore, i use exec XXX method and get error.Thank for your help!be a hardworking people!! |
|
|
|
|
|
|
exec of user-defined function