GilaMonster (9/18/2008)

---

This line

assumes that there is only one row in the inserted table. That may not be the case. What's going to...

Hi,

It was a bit hard to look up the problem you are facing, but I assume this answers your question: The error occurs on 'line 1', and all that says...

Hi,

You are mentioning a common problem, lots of folks happen to have this problem.

I'm not 100% sure, but the problem seems to be related to connection pool recycling. You can...

FYI: This Ctrl+K, Ctrol+C/Ctrl+U key combination is the default combination for (un)commenting code in all modern Microsoft code editors. Although it is not the most attractive combination to use, at...

If I get the point right, you want to use a computed column in the select query. In that case, you should use something like (sorry for possible syntax errors,...

Hi sugan,

Is your question solved, or do you still need some more explanation? If so, please clarify your question to make it possible for us to give you an answer.

Cheers,...

I'm not sure either, but it seems to me that you would like to insert a non-NULL value in the temp table, because a NULL value is not possible (are...

Of course, but that will bless you with a serious performance issue when talking about > 500,000 rows (as there are in our table) 😉 . I did not find...

Many SQL users do not...

@RBarryYoung: Perfect! I did not know this works until now (we always use a kind of fulltext indexing for this).

The only drawback for this syntax is that...

Indeed, the new TRY..CATCH construct should be used. The main reason for me would also be not to type the @@ERROR check after each command, but it has more advantages,...

Congrats 😀 ! Enjoy it! Did you pass at once?

About braindumps etc. etc.: would those guys know what they are doing in real life, that would not bother me so...

The exam fee in The Netherlands (as I heard in all of Europe) is € 140,-. If you buy yourself the Self-paced training kit, there will be a 15% discount...

I am going for the SQL Server 2005 certification as well. I see two important reasons for SQL Server 2005 certification:

1. The coming x years SQL Server 2005 will be...

As others state: only the NVARCHAR columns already sum up to above the max answer. Therefore, I (wrongly 😉 ) selected the maximum choosable 😉 ...