Gajendra Jangid

Gajendra Jangid

  • 56
  • 31.8k
  • 1.9m

Default value for bit datatype

Mar 24 2022 3:00 PM

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)