Thursday, October 20, 2011

Add column and Populate to EXISTING table

Posted by ujwala at 7:33 AM

ALTER TABLE Table_name
ADD COLUMN_NAME varchar(20)


UPDATE [table]
SET [column] = 'Confirmed'

 

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)