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.
CREATE FUNCTION dbo.ufnCheckIDAndUSERID(@ID varchar) RETURNS bit AS BEGIN --first check if the ID is there in SQL table: IF ((SELECT count(ID) from [mydb].[dbo].[t] where ID = @ID) = 1) AND ((SELECT count(UserID) from [mydb].[dbo].[t] where ID = @ID)=1) RETURN 1 ELSE RETURN 0 END;
|Returning data in a different format||8||46|
|How to get time difference in minutes and seconds only between 2 dates||2||19|
|Getting max record but maybe not use Group BY||2||15|
|When I execute a stored proc with input parms using SQL Server 2008, I get the following error msg: Msg 8152 String or binary data would be truncated. Do you know how I can resolve this?||1||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
15 Experts available now in Live!