Tagged Questions
5
votes
1answer
104 views
Find out which columns must be specified in insert-statement
Sometimes when inserting data in a table with many columns it could be useful to know which columns must be specified if the insert-statement shouldn't fail.
I wrote this query to find out which ...
6
votes
1answer
1k views
Add DEFAULT to existing column
In Microsoft SQL server, how can I add/change the default on an existing table column using T-SQL?
