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 |
|
hotshot_21
Yak Posting Veteran
97 Posts |
 Posted - 2007-08-03 : 05:21:56
|
| any example on how to pass data from table to UDF. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-03 : 05:47:29
|
You can't "pass" data to an UDF from a table.You can however select data in an UDF from a table.With SQL Server 2008 and later, you can pass a table as a parameter to an UDF.With SQL Server 2005 and 2000, you can pass XML data as a paramater.With all versions of SQL Server you can pass a list of separated values as VARCHAR or TEXT as a parameters for an UDF.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
hotshot_21
Yak Posting Veteran
97 Posts |
Posted - 2007-08-03 : 06:17:48
|
| i have a table which contains a row ,now the value in tis row is to be used by a function.how do i refer to that table values in udf |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2007-08-03 : 07:33:12
|
| select dbo.YourFunction(a.ColumName)from table1 aMake sure you put the dbo, or whoever the owner is, in the function callJim |
|
|
|
|
|
|
pass data from Table to UDF