Horje
alter column to not null with default value sql server Code Example
alter column to not null with default value sql server 
ALTER TABLE SomeTable
        ADD SomeCol Bit NULL --Or NOT NULL.
 CONSTRAINT D_SomeTable_SomeCol --When Omitted a Default-Constraint Name is autogenerated.
    DEFAULT (0)--Optional Default-Constraint.
WITH VALUES --Add if Column is Nullable and you want the Default Value for Existing Records.
Source: stackoverflow.com



Sql

Related
auto increment column in mysql query results Code Example auto increment column in mysql query results Code Example
gremove folder from git Code Example gremove folder from git Code Example
oracle grant on all tables in schema Code Example oracle grant on all tables in schema Code Example
sql server today minus n Code Example sql server today minus n Code Example
oracle grant select on schema Code Example oracle grant select on schema Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje