You are here: Re: Limitations in a query !! « MsSQL Server « IT news, forums, messages
Re: Limitations in a query !!

Posted by harsha.21aug on 10/02/60 11:54

Thanx alot Roy. :)

Roy Harvey wrote:
> On 2 Aug 2006 05:31:03 -0700, harsha.21aug@gmail.com wrote:
>
> >Hi all there,
> > I'm a newbee to this forum. I've a question, is there any limitation
> >on "IN" clause in select query.
> >for example :
> >"SELECT EMP_ID, EMP_NAME FROM EMPLOYEE WHERE EMP_ID IN
> >('EMP1001','EMP1002','EMP1003', etc, etc, so on)".
>
> There doesn't seem to be a documented limit, but if the list gets too
> long it should be in a table, not in-line code.
>
> >I've read at some documentation that there is a limitation for Columns
> >in a table and i.e. we can have only 1024 columns per table, is this
> >true?
>
> Yes, the limit is 1024 columns in a table. Any database design that
> comes close to this, much less needs to exceed it, is probably
> questionable.
>
> >Plz help me !!
> >
> >Thanx in advance.
> >
> >Kind Regards,
> >Harry
>
> Roy Harvey
> Beacon Falls, CT

 

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

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