Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
ALTER TRIGGER trigger1 ON TABLE1 INSTEAD OF DELETE AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; DECLARE @var1 varchar(20) DECLARE @var2 datetime DECLARE @var3 datetime DECLARE @var4 datetime DECLARE @var5 TINYINT DECLARE @var6 VARCHAR(10) SET @var2 = getDate() SELECT @var1 = uid, @var3 = var3, @var4 = var4, @var5 = var5 FROM DELETED IF @var3 < 1 BEGIN INSERT INTO TABLE2 (var1, var2, var3, var4, var5) VALUES (@var1, @var2, @var3, @var4, @var5) END DELETE FROM TABLE1 WHERE uid = @var1 END
|SQL Server 2005 - reduce database/logfile size on system that is running out of disk space||36||42|
|Sql Data via Excel--performance issues||2||55|
|How to simplify my SQL statement?||14||50|
|My Query is not giving correct result. Please help||5||30|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!