Posted by Erland Sommarskog on 01/10/07 11:24

(othellomy@yahoo.com) writes:
> Okay. Since we are on the subject, I fail to understand why SQL Server
> 2K would return more than one row. If object_id('sysobejcts')
> returns 1 then there is only one row with that id in sysobjects table.

Whatever that has to do with anything. The condition is still 1 = 1.

> I would like to look at the code of object_id() and what datatype it
> returns only if I can find it! (That's a different issue)

There is no code stored in SQL Server for tables. The easiest way to
see the column definitions is sp_help.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: 'aging' tables
• Prev in forum: Re: Querying different databases
• Thread view: Re: Redefining an auto-generated primary key constraint name

[Reply to this message]