What's wrong in this query?

SELECT CHARINDEX('_', name) FirstIndexOf,

--CHARINDEX('_', name)+1,

CHARINDEX('_', name, (CHARINDEX('_', name)+1)) SecondIndexOf,

charindex('_',name, CHARINDEX('_',name,(charindex('_',name ) + 1 )) + 1 ) ThirdIndexOf,

charindex('_',name,CHARINDEX('_',name,(charindex('_', name ,(charindex('_',name ) + 1 )) + 1...

Never heard of such property "pass through" before. But while reading the question multiple times and by doing a smart elimination, picked up the correct option.

You can think to run extended events. Much lighter compared to Profiler.

I have another related question. I found that in bizmsgbox db the VLF count is 500+ and the db log file growth parameter is set as 100 MB. Question is,...

Pretty useful links- thanks

If there is already a mentioned option to have a Diff backup then no point someone will be interested to restore all subsequent Tlog backups after the full bkp!

You can even run like this:- (using angular brackets)

CREATE TABLE [SELECT2] ("TABLE" int)

Nice one.

V strange

if you try any of the below, the results will be:

"Msg 8115, Level 16, State 2, Line 1

Arithmetic overflow error converting expression to data type numeric."

SELECT round(.999,0);

SELECT round(.999,1);

SELECT round(.999,2);

but,...

Nice post.

But, one question here, do we not need to restore "DQS_STAGING_DATA" database also?

Will the database be accessible if one of the files go offline?

I write PS query to get the details.

Was an easy nice question. Thanks.

Hi Steve

After we tick the answers, it will be good if we still can see the options so that while we see the correct answer, we will be able to...

No response by Anyone though. Perhaps, I tested this and it works.