Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
USE [GPSOL] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[UpdatedImeiNumber] ON [dbo].[Newtbl_DeviceMaster] -- table name AFTER UPDATE AS declare @imeiNumber as varchar(50) = '' begin IF EXISTS ( SELECT I.nIMEINo FROM INSERTED I JOIN DELETED D -- make sure to compare inserted with (same) deleted IMEI ON D.nIMEINo = I.nIMEINo AND D.nIMEINo <> I.nIMEINo -- only IMEI with changed name ) select @imeiNumber = (SELECT nIMEINo FROM Inserted) print 'inserting dummy record' insert into tblCommonTrackingData (vSequenceID, vpkDeviceID, dGPSDateTime) values('1', @imeiNumber, GETDATE()) end
select @imeiNumber = (SELECT nIMEINo FROM Inserted)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.