l.vignando (12/19/2014)

---

I tried on Sql 2005,

Msg 139, Level 15, State 1, Line 0

Cannot assign a default value to a local variable.

Msg 137, Level 15, State 2, Line 4

Must declare the...

Nice and easy...

I have normally no problem here for getting day's off, or for taking holiday at all. When you have young kids it's for us cheaper to take the time off...

I am always surprised that when the question and answers hint that the database is not case sensitive there is no mention about this. All our databases are case sensitive...

None of the answers are correct when you take into account the names are with a capital and the answers are lower case, the question was to give all names...

I have a reference here that states that the last three are distinct, top then order by. This is from the book inside Microsoft SQL server 2008 - T-SQL Querying....

This is me last year, never did anything like this when I was young (we didn't do Halloween in the Netherlands)

Scared a few korfball club members that night.

(See attachment)

graymer (2/5/2010)

---

I'm surprised at how many are saying Notepad++. That's my favorite too. I just wish my current situation would allow me to use it. So it's back to just...

I agree that there should be at least one more record in the example to make sense of the suggested answer. But if you read this part:

If I want to...

Due to an error in the variable name I chose the wrong answer. Interesting to read more about while loop levels, although who would ever need/create a query with...

There is nothing indicating if the database setting is case sensitive, our databases are. Therefore I went for different answers than the one seen as correct.

Would I have been correct...

To make sure that you can find the time of truncation you have to adjust the query a bit, as you can't find the time if another action has been...

I have found these things very interesting and wonder if I have 'enough' understanding of a subject to consider myself as having the basic skills. As mentioned, I do not...

Richard Warr (9/16/2013)

---

This isn't a "nice and simple" or "easy one" at all. Although the explanation is wrong the question illustrates a very subtle nuance with the way scripts are...

We have checked the security settings of the other tables and all settings are the same. There is no special permission set to the tables that are visible.

Is there...