Interesting question, and my answer were pure guesswork. I would argue with the first kind, as arguments to function calls or procedures. Although they can be varied, I don't regard...

Lokesh Vij (8/15/2012)

---

Keld Laursen (VFL) (8/15/2012)

---

It is also worth noting that you have no method of resetting the identity counter for the table.

Thanks for the question. I were fairly sure...

It is also worth noting that you have no method of resetting the identity counter for the table.

Thanks for the question. I were fairly sure that I had it right...

charles.byrne (8/7/2012)

---

That seems a little complicated for a Fiscal Year function.

The Fiscal Year Logic can be pared down to

select YEAR(DATEADD(m,3,RegistrationDate)) as Fyear

...

Nice article.

As I have to work with harvest years, going from August to July the next year, it is of great interest to me as well.

I am just wondering: Is...

Indeed!

I also saw this as a rewrite of the question a few days back. Didn't really catch the @/# difference in all the jpeg artifacts. :Whistling:

This question reminds me of...

As the question is worded, I would expect explicit indices to be creatable for the "correct" answer to be correct. Otherwise, why not just say "create indices" as the primary...

Darn. I should have done a little research there.

I have to admit that I were wrong 🙁

Thanks for the question. Always good to get these little tidbits.

I am one of those that (mis)read the question.

You asked "Can a foreign key be created", and the answer to that were a no-brainer as the referenced table/column needs to...

Missed one here :angry:

I knew that locks would escalate, so I checked what the rowlock hint would do.

This article hinted (to me at least) that the escalation would be put...

Well, I didn't catch the error on the select from Foobar, but just thought about locking while selecting/inserting.

I didn't really look into the temp table as this should be local...

Thank you for the question.

I deduced the result using operator precedence and parsing the input by hand (or head?).

Typed it into my local, friendly SSMS, and got the same result.

Although...

Good question. Thanks.

Although I had never used BrokerSend before, I had done something similar on linked servers, ending up in the same error.

I would thing the devil were in the details.

In fact a lot of the questions would fail if not for the fact that the numeric in the question is in...

Koen Verbeeck (2/14/2012)

---

The semicolon is not yet obligated, except when using the WITH clause. This probably...