Hi,

Change table:

alter table SINHVIEN

alter column MATKHAU varbinary(max) not null

Change SP:

Alter PROCEDURE SP_INS_SINHVIEN

@MASVnvarchar(20),

@HOTENnvarchar(100),

@NGAYSINHdatetime,

@DIACHI nvarchar(200),

@MALOPvarchar(20),

@TENDN nvarchar(100),

@MATKHAUvarchar(8000)

AS

INSERT INTO SINHVIEN

VALUES

(

@MASV,

@HOTEN,

@NGAYSINH,

@DIACHI,

@MALOP,

@TENDN,

convert(varbinary(max),HASHBYTES('MD5',@MATKHAU))

)

GO

Regards

IgorMi