how to alter table?

Article View: bit.databases.mssql-l

Article #95

Back to bit.databases.mssql-l Previous Next

#95

From: Yeh Hung Tan
Date: Fri, 26 May 2000 00:00

14 lines
1732 bytes

I am develop web site using ASP and SQL server.
Anyone tell me how to do modify the datatype of a table field?

I using the following command but it doesn't work.

sqlStatement = "ALTER TABLE register MODIFY STATE char(50)"
rs.open sqlStatement,conn,1,3

the error message return:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near
'STATE'.

Technical Details

Message-ID: <392e4181.0@news2.tm.net.my>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fb9aa,9bffa6505087adae,start
X-Google-Attributes: gidfb9aa,public
X-Google-Thread: 107c4e,9bffa6505087adae,start
X-Google-Attributes: gid107c4e,public
X-Google-Thread: 107d7d,9bffa6505087adae,start
X-Google-Attributes: gid107d7d,public
X-Google-Thread: 10cb39,9bffa6505087adae,start
X-Google-Attributes: gid10cb39,public
X-Google-Thread: 104de1,9bffa6505087adae,start
X-Google-Attributes: gid104de1,public
X-Google-Thread: f6611,9bffa6505087adae,start
X-Google-Attributes: gidf6611,public
X-Google-Thread: fa31c,9bffa6505087adae,start
X-Google-Attributes: gidfa31c,public
From: "Yeh Hung Tan" <hung79@tm.net.my>
Subject: how to alter table?
Date: 2000/05/26
Message-ID: <392e4181.0@news2.tm.net.my>
X-Deja-AN: 627512563
X-NNTP-Posting-Host: sc-155-52.tm.net.my
X-Trace: 26 May 2000 17:18:57 +0800, sc-155-52.tm.net.my
Organization: TMnet Malaysia
X-MSMail-Priority: Normal
X-Priority: 3
Newsgroups: bit.databases.mssql-l,comp.databases.ms-sqlserver,microsoft.public.inetserver.asp.components,microsoft.public.inetserver.asp.db,microsoft.public.inetserver.asp.faq,microsoft.public.inetserver.asp.general,microsoft.public.sqlserver.connect,microsoft
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200