This is a very good question, thank you Dave. The key here is the index_id: if the table has a clustered index then there will be a record in the...

Unfortunately, this perfectly valid syntax is not valid in Access where you will have to revert to something nasty like this :w00t::

delete from EXISTING

where MTR_SRL_NO...

Your syntax is correct. The reason that it does not parse correctly is probably because you have the database in compat 80 (SQL Server 2005 with level set back to...

It is flexible. CLR procedures in SQL Server, any .NET code can use one of the...

This is an excellent question, kinda reminded me of good ol' days when I worked with Access :-), thank you Timothy. The difference between Access and SQL Server is caused...

This is a good basic question, but the part of explanation is totally wrong. I am referring to this:

However, the test above shows that this is applicable only to CHAR...

honza.mf (10/1/2010)

---

Thank you Oleg, well done.

It has only one little bug: You start new transaction allways. It is unsafe as you can nest several transactions.

I prefer in such a construct...

Hugo Kornelis (10/1/2010)

---

Exactly what change are you refering to? As far as I know, the effect of ROLLBACK in a trigger in current versions is the same as it was...

Wow, this is so ridiculous. The referenced BOL page clearly states:

The answer, however includes the opposite and still claims it as a correct...

Percent sign means 0 or more of any characters, and underscore means exactly 1 of any characters. If you need to find the match for the value which itself should...

I did not quite understand the "you used for loop" part. I don't have any loop in the query. If your requirement to still get the crosstab including parameters...

Jeff,

So far, I can see that I use the same setup as far as the tally creation is concerned. The collation is of course the same as well. You are...

Jeff,

I am terribly sorry, but there is no way that your test reflects the picture. I ran Split8K and xml only tests and results I get are totally different. First,...

Yes, the pivot should do it assuming that your database is at compat 90. The only thing I had to change is the right outer join part, it is not...

Hugo Kornelis (9/3/2010)

---

- Restore and backup:

You could argue that this is simply copying pages from one place to another. What is on the page is irrelevant. The internal code to...