KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a table called sample and it has a column called [__INSERT_DATE] which is null. Now I want to alter the column with default as getdate() . When I tried the following it gave me an error. ALTER TABLE sample ALTER COLUMN [__INSERT_DATE] [datetime] DEFAULT (getdate()) NULL) Can anyone tell me what the problem is?
Tags (comma-separated)
Save Edits
Cancel