The HTML Entities for “smart quotes” are:
“ and ”
You can remember them as left double quote and right double quote.
Here's a simple SQL statement to add a varchar column of size 100 to a table:
ALTER TABLE tablename ADD COLUMN columnName varchar(100);
XML