Hassle-free live chat software re-imagined for business growth. 2 users, always free.
USE [prd_customers] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TRIGGER [dbo].[SetFollowUp] ON [dbo].[DATA] AFTER UPDATE AS SET NOCOUNT ON; INSERT INTO dbo.FOLLOWUP ( RecordIdFK, FullName, Address, City, State, Zip, PhoneNumber, eMail, Notes) SELECT i.RecordId, i.FullName, i.Address, i.City, i.State, i.Zip, i.PhoneNumber, i.eMail, i.Notes FROM inserted i WHERE PhoneNumber is not null
|Early & clean exit from a maintenance plan (T-SQL Execution task)||5||21|
|SQL Server Update Query Streamline||4||14|
|TSQL - 'WHILE EXIST' loop and LIKE % operator||4||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!