You are here: Re: Redefining an auto-generated primary key constraint name « MsSQL Server « IT news, forums, messages
Re: Redefining an auto-generated primary key constraint name

Posted by othellomy on 01/10/07 09:56

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.
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)

Erland Sommarskog wrote:
> (othellomy@yahoo.com) writes:
> > When I execute the following query:
> > select name
> > from sysobjects
> > where object_id('sysobjects') = 1
> > Why do I get all the rows instead of only one?
>
> You would get either many or zero rows, depending on the object id of
> sysobjects. On SQL 2000 the query returns many rows, so obviously sysobjects
> has id = 1 there. On SQL 2005 you get no rows at all. (On SQL 2005
> sysobjects is no longer a table.)
>
>
> >Because when I tried to run a similar query (to test) on
> >another server (sql Anywhere)
>
> SQL Anywhere is an entirely different engine, alhough I can guess that
> Sybase has added sysobjects & co since they acquired the product.
>
> --
> 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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация