var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Alter Table Help
Need to add RowGUID column to tables and I'm running into some trouble. Not really familiar with all the uses of ALTER TABLE.
Attempting to execute this:
ALTER TABLE My_Table ADD [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL
However, I'm sure I'm getting error messages because the column is being inserted as NULL values. So I want to give it a DEFAULT value I just don't know the best way or the syntax for that statement.
Suggestions? -Please help!
ALTER TABLE My_Table ADD [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL default(newid())