@tablename is a table variable in SQL Server but it usually has to be declared before being used.
What database are you using? On Mon, Jun 13, 2011 at 10:08 AM, Michael Dinowitz <[email protected]> wrote: > > I'm looking at a query in someones code and it has something that is > unfamiliar to me. The select statement has: > FROM dbo.Person@Reliance > > What is the @ sign? Neither Person nor Reliance are tables in the database. > > Also, there is an Order By that just has numbers, no fields to sort by: > ORDER BY 8,9,6 > > Can anyone educate me on this? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3412 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
