here is what I have ended up with....and there are more, since I have to convert 6 of them. does this take long? I mean, I have 18 million rows to change...does sql server do this fairly quick or is this a laborious line by line thing, that I should start a campfire and get some marshmallows for?
USE reports ALTER TABLE NewBackupReports ADD COLUMN roadBlock_asVC varchar(255) NULL UPDATE NewBackupReports SET roadBlock_asVC = CAST(roadBlock AS varchar(255)) WHERE roadBlock IS NOT NULL ALTER TABLE NewBackupReports DROP COLUMN roadBlock EXEC sp_rename 'NewBackupReports.roadBlock_asVC' 'roadBlock' 'COLUMN' tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -----Original Message----- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 3:31 PM To: CF-Talk Subject: RE: alter table question see.... trust... but verify! -----Original Message----- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 1:04 PM To: CF-Talk Subject: RE: alter table question > so, I will most likely use the suggestion that mark kruger > suggested.... Erm, that's exactly what I suggested, but without the code :-P ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
