TomThomson (9/11/2014)

---

Koen Verbeeck (9/11/2014)

---

Vimal Lohani (9/11/2014)

---

TRUNCATE TABLE removes the data by deallocating the data pages used to store the table data and records only the page deallocations in the transaction...

I see, thank you Tom

Although I answered more based on the instinct that the data is safely recovered after a rollback. I am still wandering why have I thought that TRUNCATE would drop the...

Nice question, thank you

it says something about login failed for user ... I wander if this is a local user id or is defined properly.

so I would search around this user id and...

Yes, you need to define the data source for this report from report's Properties, after you have uploaded it.

yes, nice question, thanks for it.

what characters is not accepted. It should work fine.

You can show the parameter value on the report to test it's values.

Is it possible to attach the RDL file ?

Cheers,

Iulian

OK I got it, so the key is in SET IMPLICIT_TRANSACTIONS ON ... interesting. Thank you for the question.

Nice sample to spot the behavior, thanks for putting it together.

I wander if this is supposed to work like this, or is actually a bug.

Yes , multiple choice is not allowed.

Though it says I answered correctly if I chose one option only.

Nice question anyway, thank you.

TomThomson (7/30/2014)

---

Nice question, correct answer, appallingly wrong explanation.

The reason this works is nothing to do with scope (which isn't the batch unless the declaration is the first statement in the...

Nice one , thank you for the question

Nice one , thanks

Koen Verbeeck (7/15/2014)

---

Iulian -207023 (7/15/2014)

---

Koen Verbeeck (7/15/2014)

---

Indeed, the file is formatted quite well in the sense that it is very predictable.

How I would do it:

* read the file in line...