er

[Steve95]

Hi All

Iam new to sql and stored procedures.....

In a sp iam looking at a select statement has 'er' in it, what does do and mean?

eg.

from fin_datawh.dbo.tbl_Report_Exc_Rate er where rate_type_code like 'syse%'

 

[ptheriault]

er is a table alias here.

For example

select er.*
from fin_datawh.dbo.tbl_Report_Exc_Rate er

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[gmmastros]

er is a table alias. It is a shorthand notation that can be used instead of specifying the full table name. In this case it is particularly useful because it specifies a table from another database (fin_datawh).

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[monksnake]

You may be used to seeing alias' with the extra word 'AS' in it, so your example may be more familiar written like this:

from fin_datawh.dbo.tbl_Report_Exc_Rate [!]as[/!] er where rate_type_code like 'syse%'

<.