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 |
|
swarn
Starting Member
12 Posts |
 Posted - 2003-01-21 : 06:41:59
|
| Hi folksI need to know that is this possible to call User Define Functions from ASP just like Store Procedures???I have tried to find this information but so far no luck. please any body let me know..thanksswarn |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-01-21 : 06:48:10
|
| udf's return a value so from asp you canselect dbo.myudf()or for tablesselect * from dbo.myudf()==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
swarn
Starting Member
12 Posts |
Posted - 2003-01-21 : 06:57:10
|
thanks nr for quick reply.. just another question regard to same subject that so i can use following statement in ASP code as any normal sql statement to display results???? any where i can access to sample examples or scripts???thanks againswarnquote:
udf's return a value so from asp you canselect dbo.myudf()or for tablesselect * from dbo.myudf()==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy.
|
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-01-21 : 07:06:28
|
| Yep. Try it and see.But if you want to do this consider making the udf's into stored procedures or putting SP wrappers around them.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
User Define Function