Somebody used Keyword OBJECT_ID as a column name...  
Author Message
Carel





PostPosted: Wed May 16 10:40:01 CDT 2007 Top

SQL Server Developer >> Somebody used Keyword OBJECT_ID as a column name...

The Transact-SQL Reference for OBJECT_ID
Returns the database object identification number.

What are the Consequences of Using Reserved Keyword OBJECT_ID as a column
name in SQL Server 2000?

Has anybody out there ran into any problems where somebody named a column
OBJECT_ID?

If so would you be willing to share your experience?

-- Thanks
~ SPARKER ~

SQL Server304  
 
 
KH





PostPosted: Wed May 16 10:40:01 CDT 2007 Top

SQL Server Developer >> Somebody used Keyword OBJECT_ID as a column name... Put it in brackets to use in a query:

SELECT [object_id] FROM ...




> The Transact-SQL Reference for OBJECT_ID
> Returns the database object identification number.
>
> What are the Consequences of Using Reserved Keyword OBJECT_ID as a column
> name in SQL Server 2000?
>
> Has anybody out there ran into any problems where somebody named a column
> OBJECT_ID?
>
> If so would you be willing to share your experience?
>
> -- Thanks
> ~ SPARKER ~
 
 
SpamFreePlease





PostPosted: Wed May 16 17:16:01 CDT 2007 Top

SQL Server Developer >> Somebody used Keyword OBJECT_ID as a column name... I am aware of that but thanks anyway.
--
~ SPARKER ~




> Put it in brackets to use in a query:
>
> SELECT [object_id] FROM ...
>
>

>
> > The Transact-SQL Reference for OBJECT_ID
> > Returns the database object identification number.
> >
> > What are the Consequences of Using Reserved Keyword OBJECT_ID as a column
> > name in SQL Server 2000?
> >
> > Has anybody out there ran into any problems where somebody named a column
> > OBJECT_ID?
> >
> > If so would you be willing to share your experience?
> >
> > -- Thanks
> > ~ SPARKER ~