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.
use Dictionary insert into TblCurrentWords (Word_ID, Word, MyDateTimeCol) select Word + GETDATE() AS CurrentDateTime, word, GETDATE() AS MyDateTimeCol from TblWords where word is not null and PATINDEX('%[0-9]%',Word)=0 group by word order by word
|SQL Server - Set Field Values ito Zero Based on Related Table||4||22|
|Update a text value in another table||10||38|
|Deal with apostrophe in stored procedures||8||41|
|Passing Parameter to Stored Procedure||4||23|