How to set the Default Status False in Sqlserver

Pankaj Kumar Choudhary11y ago

Hello @Venkata use this method

alter table Table_Name
add constraint cons default 1 for Column_Name

Venkata Subbareddy11y ago

Near Synatax error in Default

Venkata Subbareddy11y ago

Zero(0)

Piyush Pansuriya11y ago

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

Venkata Subbareddy11y ago

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 Pansuriya11y ago

Hello,

CREATE TABLE Tb_Table1

(

ID INT,

BitColumn BIT DEFAULT 0

)

GO

Use BIT datatype and default value set 0