var queries = new[]{ @"SELECT [CarrierFid], [pelacknumber], [Speed], [Timeoverspeed] FROM [dbo].[OverSpeedAlert] "+ " WHERE visited = 0 AND CONVERT(varchar(10), Timeoverspeed )= FORMAT(GETDATE(),'dd/MM/yyyy') "+ " and CarrierFid in ( "+ " SELECT dbo.AlarmsCarrier.carrierFid "+ " FROM dbo.AlarmsCarrier INNER JOIN "+ " dbo.AlarmUsers ON dbo.AlarmsCarrier.AlarmCarrierid = dbo.AlarmUsers.AlarmCarrierFid INNER JOIN "+ " dbo.Users ON dbo.AlarmUsers.UserFid = dbo.Users.ID "+ " WHERE (dbo.Users.UserName = '"+ username +"'))" };
SqlDependency
Creating a Query for Notification | Microsoft Docs[^]: Query notifications are supported for SELECT statements that meet the following requirements: … The statement must not contain subqueries… … The statement must not use any nondeterministic functions…
In
GETDATE
SELECT dbo.AlarmsCarrier.carrierFid, dbo.AlarmUsers.UserFid FROM dbo.AlarmsCarrier INNER JOIN dbo.AlarmUsers ON dbo.AlarmsCarrier.AlarmCarrierid = dbo.AlarmUsers.AlarmCarrierFid
SELECT
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)