Vey nice question....

but my response was wrong 🙁

+1 🙂

nice question..

learn something new today!!:-)

why query for step 2 result only 5 rows--

What will the original SELECT * FROM VOrder_Details (Step 2 above) statement return when executed?

As, I think that when we made...

Hi,

sorry I forget about passing parameters..

chk this one, hope this one helps -

IF (@p = 'NULL' OR @p IS NULL)

BEGIN

SELECT * FROM abc WHERE name1 IS NULL

END

ELSE

BEGIN

SELECT * FROM...

Please attach a screenshot of sample data or post query which you wrote so that we can do modification in that and give you desired result,

select * from abc

where column_name IS NULL

nice question

+1 😛

wrong answer 🙁

I learned a lot from transaction questions 🙂

When 'x' is getting inserted with WITh(ignore_dup_key=ON) then in select statement why 'x' is not getting returned?

hi,

Can anyone tell me How to check whether the database is in single user mode or multi user mode?

+1 🙂

Thanks for the explanation Hugo

I write that statement as there was no FROM clause in his query.

I agreed in using alias in FROM clause but he pasted query in whis he didnt...

Can you please attached the screenshots of what type of error you are getting..so we can look into it in a better way