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.
set statistics time on set statistics io on declare @Topid_in int -- The top level we want to resolve children for select @Topid_in = 2953; with subchildren (Category_ChildID, Category_ParentID) AS ( select Category_ChildID, Category_ParentID from Category_Relationship where Category_ChildID = @Topid_in union all select Category_Relationship.Category_ChildID, Category_Relationship.Category_ParentID from Category_Relationship inner join subchildren on Category_Relationship.Category_ParentID = subchildren.Category_ParentID ) select * from subchildren
|SQL Server encoding for storing Indian languages||9||37|
|How to pass a parameter to limit the colums returned in Stored Procedure SQL 2016||2||30|
|I am using SQL Server 2008. Is there a way to pass in 2 parameters strings in the format MM/DD/YYYY and convert these strings into a DATE data type using SQL Server 2008 and then make a date compare?||3||16|
|SQL Field Length for Email Address||3||18|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
26 Experts available now in Live!