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.
SELECT @DynamicQuery = ISNULL(@DynamicQuery+' UNION ','') + 'SELECT CONVERT(varchar(max),'+COLUMN_NAME+') as varColumnName, '+@VarCusHeaderID+' as fk_Header_ID, '+@varProviderID+' as fk_ProviderID, '+@varCurIndex+' as PositionIndex, '+@varIsStatus+' as IsStatus FROM '+@TransactionTable+ ' y' +ISNULL(' WHERE '+@TableWhere,'') FROM INFORMATION_SCHEMA.COLUMNS WHERE (table_name = @TransactionTable AND COLUMN_NAME IN ( 'Text1', 'Text2', 'Text3', 'Text4', 'Text5', 'Text6', 'Text7', 'Text8', 'Text9', 'Text10' ) ) ORDER BY SUBSTRING(COLUMN_NAME,5,2)
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.