Cannot resolve collation conflict for equal to operation. In MS SQL SERVER, the collation can be set at the column level.
I have received few emails and comments about my post SQL SERVER – T-SQL Paging Query Technique Comparison – SQL 2000 vs SQL 2005. The main question was is this can be done using CTE? Absolutely! What about Performance? It is same! Please refer above mentioned article for history of paging.
Just a week ago, my Database Team member asked me what is the best way to only select date part from datetime. When ran following command it also provide the time along with the date.
In this blog post we are going to learn how to fix XML Data Type related error.