Yeah DouglasH, you are correct. I sorted out that point and bingo. Was not that complex but seems I need a coffee break. Was stuck at this for some...

DECLARE @Expression VARCHAR(8000) = 'abcd_e_fgh',

@SearchString VARCHAR(10)= '_',

@OccuranceNumber SMALLINT = 5

DECLARE @SearchIndex...

Hi Eirikur, Thanks but this was a question with just an example. Actually it is a generic one. String could be anything and not just "abcd_e_fgh".

Though i've just sorted...

Easy one...

Easy one for me. But good basic question.

Very good question again.

Very good question on the basics.

Thanks Gail & Conor for the clarification. That helps.

Thanks Gail. So any of these four exams can be given in any sequence (as per your choice ofcourse) ?

Additionally these four exams (464-467) cover both SQL 2012 & 2014...

Simple question

Nope. I was getting following error in second spid (as per my presented scenario):

"Invalid column name 'Col5'."

And the name #Temp1 is taken here just for the example. Actually following naming...

To summarize, i've this simple procedure definition in one sql session.

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.testproc') AND type in (N'P', N'PC'))

DROP PROCEDURE dbo.testproc

GO

SET ANSI_NULLS ON

GO

SET...

I'm working in SQL server only

Comparatively easy one.

Really that helped. Overall a good question.