|
|
Posted by Karthik on 09/30/63 11:54
Harsha, See this post
http://groups.google.com/group/comp.databases.ms-sqlserver/browse_thread/thread/8605a2b10bf4faaa/f2da17b97723fe15?hl=en#f2da17b97723fe15
harsha.21aug@gmail.com wrote:
> 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]
|