T-SQL

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 1

If it's ASAP, look it up in Books Online. That's what the documentation is for.

It really depends on whether or not you're calling a scalar or table valued function.

A scalar would be within the code something like:

SELECT col1,

MyFunction(col2) AS SomeName

FROM...

Where a table valued function would be something like:

SELECT *

FROM MyFunction()

There are a lot of variations within this. Check the documentation.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

TA-472286 SSC-Addicted Points: 462 More actions · Answer 2

SSC-Addicted

Points: 462

September 29, 2008 at 11:36 am

Thanks for your Help Grant.

Regards

Tejinder