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.
UPDATE Tbl1 SET CalcFld = (select row_Number() over(ORDER by Value DESC) as Row from Tbl2 where tbl2.Id = Tbl1.Id and Tbl2.Date = '4/1/09') from Tbl1 IF @@ROWCOUNT = 0 BEGIN INSERT Tbl1 (Id, CalcFld) select Id, row_Number() over(ORDER by Value DESC) as Row from Tbl2 where Tbl2.Date = '4/1/09' END
|SQL Syntax Grouping Sum question||7||24|
|Using T-SQL (SQL Server 2008 R2) to determine whether file exist on server and delete it||4||28|
|SQL Find Carriage Return and Delete it.||3||11|
|.NET Enums [Flags] & Bitwise Design Question||6||23|