hi,
Can anyone let me know the exact definition of "What do you mean by Inline
Queries in SQL Server?.

I have heard lot of people talking about Inline Queries but when asked about
the definition of that, I am not getting the exact answer for that.

Regards
Sudhakara.T.P.

Sudhakara,

I'm guessing a query in the FROM clause of another query.  There are also
inline user-defined functions as well.

HTH

Jerry
Show quoteHide quote

This sounds like BASIC in the 1960's   when we could  use a FN command
to mimic a FORTRAN statement.

For more information on inline user-defined functions see:

Inline User-Defined Functions
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_08_73lf.asp

HTH

Jerry
Show quoteHide quote

On Fri, 30 Sep 2005 09:45:01 -0700, Sudhakara.T.P. wrote:

Hi Sudhakara.T.P.,

I'm not sure if "inline queries" is an official term (I doubt it), but
I've sometimes seen it used in the context: "Use a user-defined function
or an inline query" - in which case it means that the functionality from
the user-defined function is included in the query instead of calling
the UDF.

If done with a table-valued UDF, the result is a derived table. If done
with a scalar UDF, the result is simply an (often complicated)
expression.

Best, Hugo

Unknown Columns!
Simple query?
Can someone explain why this is not an error?
order by
scramble password