create table

CREATE TABLE [dbo].[cgmxd](
[KHID] [int] NOT NULL, 
[CGDID] [int] NOT NULL,
[XMXH] [int] NOT NULL,
[GHDWDM] [VARCHAR](20) NULL,
[RKRQ] [DATETIME] NULL,
[FPHM] [char](1) NULL,
[YPID] [INT] NULL,
[SL] [numeric](10,2) NULL,
[MRJ] [numeric](10,4) NULL,
[FDBL] [INT] NULL,
[SJJJ] [numeric](10,4) NULL,
CONSTRAINT [PK_cgmxd] PRIMARY KEY CLUSTERED 
(
[KHID] ASC ,
[CGDID] ASC ,
[XMXH] ASC 
) 
)

select CONVERT(VARCHAR(32), HashBytes('MD5', 'email@dot.com'), 2)