CREATE TABLE UserNotifications ( [Ref_NotificationType_ID] [int] NOT NULL, this is a foreign key column [From_Employee_ID] [int] NOT NULL, this is a foreign key column [To_Empoyee_ID] [int] NOT NULL, this is a foreign key column [Ref_Identity_ID] [bigint] NOT NULL, this is a foreign key column [Identity_Type] [smallint] NOT NULL, [VersionNumber] [int] NOT NULL, [Priority] [bit] NOT NULL, [Created_DateTime] [datetime] NOT NULL, [Created_By] [varchar](max) NOT NULL, [Last_Updated_DateTime] [datetime] NULL, [Last_Updated_By] [varchar](max) NULL, [HasUserRead] [bit] NOT NULL, [IsActive] [bit] NOT NULL, [Flag] [bit] NOT NULL )
update UserNotifications set field=value where Ref_NotificationType_ID = 1 and From_Employee_ID = 100 and To_Empoyee_ID = 200 and ...
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)