sql server trigger procedure sha256

trigger

 

USE [WSC_FCDB]
GO
/****** Object: Trigger [dbo].[FC_OPC_DataLog_Minute_Insert_Trigger] Script Date: 2020/9/29 15:57:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[FC_OPC_DataLog_Minute_Insert_Trigger] ON [dbo].[FC_OPC_DataLog_Minute]
FOR INSERT
AS
begin
insert into FC_OPC_DataLog_ZK(ID,TagID,TagName,TagValue,CreateTime,RecordFlag) select ID as ID,TagID,TagName,TagValue,CreateTime,RecordFlag from inserted
--insert into FC_OPC_DataLog_ZK(ID,TagID,TagName,TagValue,CreateTime,RecordFlag) select SCOPE_IDENTITY() as ID,TagID,TagName,TagValue,CreateTime,RecordFlag from inserted
End

Create TRIGGER [dbo].[SYS_USER_InsertTrigger] ON [dbo].[SYS_USER]
FOR INSERT
AS
begin
insert into FINEDB.dbo.fine_user(id,creationType,enable,lastOperationType,password,realName,userName)
select ID as ID,1,1,1,Lower(convert(NVarchar(2000), HASHBYTES('SHA2_256',User_Pwd),2)),[User_C_Name],User_Name from inserted
--insert into FC_OPC_DataLog_ZK(ID,TagID,TagName,TagValue,CreateTime,RecordFlag) select SCOPE_IDENTITY() as ID,TagID,TagName,TagValue,CreateTime,RecordFlag from inserted
End
go

 

Sql SHA256

select  Lower(convert(NVarchar(2000), HASHBYTES('SHA2_256','456789'),2))

 

 

/* insert into #FC_OPC_LogTableTmp(ID,TagID,TagName,TagValue,TypeFlag,CreateTime,RecordFlag)
select ID,TagID,TagName,TagValue,TypeFlag,@CreateTime as CreateTime,CASE WHEN TypeFlag = 1 THEN 1 ELSE 0 END as RecordFlag from (
select ID,TagID,TagName,TagValue,TypeFlag,ROW_NUMBER()over(PARTITION By TagID ORDER BY CreateTime DESC) as rownum from FC_OPC_DataLog with(nolock) where ProFlag=0
)as b
where rownum =1 */