将多个位列转换为一个字段

测试数据

CREATE TABLE [dbo].[testbit](
    [StaffId] [int] NULL,
    [type1] [bit] NOT NULL,
    [type2] [bit] NULL,
    [type3] [bit] NULL,
    [type4] [bit] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[testbit] ([StaffId], [type1], [type2], [type3], [type4]) VALUES (1, 1, 0, 0, 1)
GO
INSERT [dbo].[testbit] ([StaffId], [type1], [type2], [type3], [type4]) VALUES (2, 0, 1, 0, 0)
GO
INSERT [dbo].[testbit] ([StaffId], [type1], [type2], [type3], [type4]) VALUES (3, 1, 1, 1, 1)
GO