any empirical tests - and would be
interested to hear others thoughts/knowledge...
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 04 September 2001 19:36
To: CF-Talk
Subject: RE: help with moving from access to sql server
Can't you just use a Convert
Could anybody help me with the following error regarding datatypes that
I am getting having just moved my database from Access to SQL Server 7.
I am receiving the following error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot
Why do you need the GROUP BY clause at all?
I don't see any aggregate functions (COUNT, SUM etc)
Also, which column is a bit column and does it really need to be?
Nick
**
Information in this email is confidential and may be
: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: 04 September 2001 15:48
To: CF-Talk
Subject: RE: help with moving from access to sql server
Why do you need the GROUP BY clause at all?
I don't see any aggregate functions (COUNT, SUM etc)
Also, which column is a bit column and does it really need
use cast() or convert() to change the datatype in your qry
On Tue, 4 Sep 2001, Declan Maher wrote:
Could anybody help me with the following error regarding datatypes that
I am getting having just moved my database from Access to SQL Server 7.
I am receiving the following error:
ODBC Error
ACP
Internet Application Developer
Telecommunication Systems Inc.
[EMAIL PROTECTED]
-Original Message-
From: Declan Maher [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 7:41 AM
To: CF-Talk
Subject: help with moving from
, September 04, 2001 1:36 PM
To: CF-Talk
Subject: RE: help with moving from access to sql server
BIT is the correct type to use for a boolean value, but you must
think about
it first since BIT typed columns cannot be included in a GROUP BY clauses.
TINYINT is the one to use for boolean values if you
7 matches
Mail list logo