4
Answers

Default value for bit datatype

alter table tblaspnet_Users add column IsQRScanned BIT NOT NULL DEFAULT 0 

ERROR: column "isqrscanned" is of type bit but default expression is of type integer HINT: You will need to rewrite or cast the expression. SQL state: 42804

Answers (4)