default number in sql
snippet in sql

default number in sql

user2479

//Sql Server

//Add a table 
ALTER TABLE clients ADD Points INT DEFAULT 0
//Edit an existing table
ALTER TABLE clients ADD CONSTRAINT points DEFAULT 0 FOR Points

alter table add default sql

user5165

// For SQL Server

ALTER TABLE Persons
ADD CONSTRAINT df_City
DEFAULT 'Sandnes' FOR City;

set default column value sql

user2498

Name Varchar(255) default "Fred"