DECLARE @ms INT
DECLARE @ss BIGINT
DECLARE @passwordDate BIGINT
BEGIN
set @ss = DATEDIFF(Ss,'1970-01-01',getDate())
set @ms = DATEPART(Ms,getDate())
set @passwordDate = @ss*1000 + @ms
UPDATE USERS SET PASSWORDDATE= @passwordDate
END
DECLARE @ss BIGINT
DECLARE @passwordDate BIGINT
BEGIN
set @ss = DATEDIFF(Ss,'1970-01-01',getDate())
set @ms = DATEPART(Ms,getDate())
set @passwordDate = @ss*1000 + @ms
UPDATE USERS SET PASSWORDDATE= @passwordDate
END