How to set the Default Status False in Sqlserver

Question

Hi every one How to set The Status value automaticaaly false in my table im using sql server 2012.. Thanks& Regards subbareddy.

Pankaj Kumar Choudhary · Answer

Hello @Venkata use this method alter table Table_Name add constraint cons default 1 for Column_Name

Venkata Subbareddy · Answer

Near Synatax error in Default

Venkata Subbareddy · Answer

Zero(0)

Piyush Pansuriya · Answer

Hello are you writing o or 0 ? Here you wrote o. set it default 0 .

Venkata Subbareddy · Answer

iam writing query in the Below Hi pansuriya Please find The Error Alter Tablename Alter Column Name Bit Default o . This is iam writing Query Any Modification.. Thanks & regards subbareddy.

Piyush Pansuriya · Answer

Hello CREATE TABLE Tb_Table1 ( ID INT BitColumn BIT DEFAULT 0 ) GO Use BIT datatype and default value set 0