DERIVEDTBL question

1 Sep 2006 2:19 AM

ja

Hi,all
Could anybody tell me what does ' DERIVEDTBL' mean & how & where to use?

-ja

1 Sep 2006 2:26 AM

Kalen Delaney

Hi ja

This is not a SQL Server keyword. It is probably the alias someone gave to a
derived table, which is table expression used in a FROM clause, which must
have an alias. Where did you see this word?

You can read about derived tables in the Books Online.

--
HTH
Kalen Delaney, SQL Server MVP

Show quote

"ja" <josnd***@yahoo.com> wrote in message
news:e2zqa0WzGHA.772@TK2MSFTNGP05.phx.gbl...
> Hi,all
> Could anybody tell me what does ' DERIVEDTBL' mean & how & where to
> use?
>
> -ja
>

1 Sep 2006 3:11 AM

ja

Yes, Got the point, thanks a lot!

-ja

Show quote

"Kalen Delaney" <replies@public_newsgroups.com> Ð´ÈëÏûÏ¢ÐÂÎÅ:%23FG4I4WzGHA.2***@TK2MSFTNGP05.phx.gbl...
> Hi ja
>
> This is not a SQL Server keyword. It is probably the alias someone gave to
> a derived table, which is table expression used in a FROM clause, which
> must have an alias. Where did you see this word?
>
> You can read about derived tables in the Books Online.
>
> --
> HTH
> Kalen Delaney, SQL Server MVP
>
>
> "ja" <josnd***@yahoo.com> wrote in message
> news:e2zqa0WzGHA.772@TK2MSFTNGP05.phx.gbl...
>> Hi,all
>> Could anybody tell me what does ' DERIVEDTBL' mean & how & where to
>> use?
>>
>> -ja
>>
>
>