[AccessD] Strange limit

Just ran this straight sql query, notice 27 columns (thereabouts), IIRC in SQL the parameter limit is something like 64K.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Thursday, November 15, 2012 2:42 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Strange limit

Or is it just stopping at the OR clause?

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, November 15, 2012 11:06 AM
To: Access Developers discussion and problem solving; Sqlserver-Dba
Subject: [AccessD] Strange limit

I am running the folliowing query:

SELECT     Column_Number, Column_Name
FROM         _DataDB101.dbo.DB101_ConsumerLayout
WHERE     (Column_Number IN ('241', '54', '64', '132', '191', '186', '133',
'63', '139', '185', 
'129', '151', '201', '147', '127', '113', '261')) OR
                       (Column_Name IN ('145', '141', '187', '52', '122'))

Notice that I am asking for about 22 values in an In() clause.  SQL Server
is cutting it off after 
the 17th value returned.

I never knew there was such a limit though of course there would be some
limit.  17 is rather small.

-- 
John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-------------Disclaimer---------------

This electronic message and its contents and attachments contain information from Sentara Healthcare and is confidential or otherwise protected from disclosure. The information is intended to be for the addressee only.

If you are not the addressee, any disclosure, copy, distribution or use of the contents of this message is prohibited. If you have received this electronic message in error, please notify us immediately and destroy the original message and all copies.