newbie question. Insert column 1

[smeyer56]

I have had a SQL 7 database thrown at me and I need to add a column named FldNotes to the table tblInquirers. I am new to SQL and am not certain how to do it. I have tried the Enterprise manager but it seems to lock up when I do it. Would anyone help me please?
Thanks!

 

[nigelrivett]

alter table tblInquirers add FldNotes varchar(1000) null.

If you add it with a default then it will have to update every row in the table and may take a long time.
E-m is probably making another copy of the table and migrating the data - try scripting the commend to see.
It might be better to do that anyway
see

http://www.nigelrivett.net/AlterTableProblems.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.