October 25, 2013 at 1:17 am
HI all,
I am coding a cript and need your input,
I wanted to call a function which should retun me the index name and I want do further action on it
How do I call a function from proc to handle this?
"More Green More Oxygen !! Plant a tree today"
October 25, 2013 at 1:42 am
it depends:
A scalar value function (SVF ) is called like
Select SVFSchema.SVF( value_to_be_used )
A table value function (TVF ) is called like
Select x.col1, ...
from TVFSchema.TVF( value_to_be_used ) x
-- or
Select x.col1, T.columnA, ...
from mytable T
cross apply TVFSchema.TVF( T.columnY ) x
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply