<cfquery datasource="aff" name="Dataadd">
ALTER TABLE [dbo].[affiliated] with NOCHECK
ALTER COLUMN [dbo].[affiliated].[Affiliate_bday] int
</cfquery>
with nocheck ignores exist constraints.
Regards,
Phillip Holmes
http://www.phillipholmes.com
On 6/9/06, Tim Starling <[EMAIL PROTECTED]> wrote:
I am trying to change the data type of a column in a ms sql table and have
followed the examples that I have but I keep getting a syntax error – I'm
probably overlooking something. Here is the SQL that I am using:
<cfquery datasource="aff" name="Dataadd">
ALTER TABLE affiliated
MODIFY Affiliate_bday int;
</cfquery>
The error I get is:
Incorrect syntax near 'Affiliate_bday'.
What is the proper syntax to change the data type for a column in MS SQL? I
need to change a column that was set up as varchar to be an integer.
Thanks,
Tim
Tim Starling
Project Manager - Web Development
Global Aid Network
A ministry of Campus Crusade for Christ International
972-234-0800, extension 1335
www.gainusa.org
________________________________
This e-mail message has been scanned for Viruses and Content and
cleared by MailMarshal - For more information please visit
www.marshalsoftware.com ________________________________
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
--
Warmest Regards,
Phillip B. Holmes
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
