How to create a calculated field by the value of another field in MS-SQL?

Question

SQL Server

There is a pallets table, it has a shipmentid field.
It is necessary to add a calculated field shipped with a dimension of bits, where the value would be 1 when shipmentid is not null, and 0 when, respectively, null.
How to register it in alter table?

Answer 1

CREATE TABLE [dbo].[pallets](
  [shipmentid] [int] NULL,
  [shipped]  AS (CONVERT([bit],case when [shipmentid] IS NULL then (0) else (1) end))
) ON [PRIMARY]

With correction from d-stream and SSMS.
Or another option:

[shipped] AS (CONVERT([bit],isnull([shipmentid],(0))))

Answer 2

Trigger on insert/update?