Gajendra Jangid

Gajendra Jangid

  • 27
  • 41.2k
  • 2.2m

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)