Getting registered for SQL Notifications
-
I build an application that relies on SQL Notification to update a member in clients memory. I used a second select statement to read the members table after the original one because the original was using a view and multiple functions. Works great. But I was wondering for performance issues, is there a way to register for notification without returning a result set? Right now I have the original statement : SELECT [ID],[TemporaryID]...,ISNULL([dbo].GetProvinceName([ProvinceID], [CountryISO3], @Language), [Province]) AS Province...,[dbo].GetUserFullName([LastUpdateUser]) AS LastUpdateUser... FROM [dbo].[vw_MembersFinder] WHERE [LastUpdateDateTime] > @SyncDateTime AND [Status] = @Status So I read right after using : SELECT [ID],[FirstName],[LastName],[Address1],[Address2],[City],[ProvinceID],[PostalCode],[CountryISO3],[ManInvalidAddress] FROM [dbo].[Members] WHERE [Status] = 'A' This way I register correctly for notifications but of course I have to wait for two results sets. Any good ideas?:)