Re: ADO error
- From: "Daniel Crichton" <msnews@xxxxxxxxxxxxxxxx>
- Date: Thu, 15 Jun 2006 16:00:11 +0100
Hmm, another dig around shows that SQL Server should handle it as optional.
I'll try some tests here on my servers.
Dan
Daniel wrote to kayal on Thu, 15 Jun 2006 15:57:01 +0100:
SQL Server's syntax hasn't changed - the docs for v7 to 2005 all show that
it's ALTER TABLE [tablename] ADD <column_definition>
While the ANSI 92 standard defines the keyword COLUMN after the ADD as
optional, SQL Server doesn't allow it. SQL Server is not fully ANSI 92
compliant.
Dan
kayal wrote on Thu, 15 Jun 2006 05:49:02 -0700:
ya it worked like charm.
thanx.but y is the original syntax changed here in ms sql?
"Daniel Crichton" wrote:
kayal wrote on Thu, 15 Jun 2006 02:42:01 -0700:
"Incorrect syntax near the keyword 'COLUMN' statement(s) could not be
prepared. deferred prepare could not be completed"
can anyone please help me with this error which i get while trying to
add a column to my table.
query "alter table release add column email varchar(2));"
It would help if you specified the database server you're using too.
Assuming MS SQL Server, your problem is that you've put "column" in the
statement - with ALTER TABLE ... ADD you just specify the column
definition, eg.
alter table release add email varchar(2)
Dan
.
- Follow-Ups:
- Re: ADO error
- From: Daniel Crichton
- Re: ADO error
- References:
- Re: ADO error
- From: Daniel Crichton
- Re: ADO error
- From: Daniel Crichton
- Re: ADO error
- Prev by Date: Re: ADO error
- Next by Date: Re: ADO error
- Previous by thread: Re: ADO error
- Next by thread: Re: ADO error
- Index(es):
Relevant Pages
|
|
