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.
SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice
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.
SQL SERVER – Fix : Error : Msg 9514 Xml data type is not supported in distributed queries. Remote object ‘OPENROWSET’ has xml column(s)
In this blog post we are going to learn how to fix XML Data Type related error.
SQL SERVER – UDF – Function to Display Current Week Date and Day – Weekly Calendar
In analytics section of our product I frequently have to display the current week dates with days. Week starts from Sunday. We display the data considering days as column and date and other values in column. If today is Friday June 8, 2007. We need script which can provides days…
Read More
SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL
Update: For SQL Server 2008 there is even better method of Row Construction, please read it here : SQL SERVER – 2008 – Insert Multiple Records Using One Insert Statement – Use of Row Constructor
This is very interesting question I have received from new developer. How can I insert multiple values in table using only one insert? Now this is interesting question. When there are multiple records are to be inserted in the table following is the common way using T-SQL.
SQL SERVER – Fix : Error : Error 15401: Windows NT user or group ‘username’ not found. Check the name again.
Fix : Error : Error 15401: Windows NT user or group ‘username’ not found. Check the name again. This is quite a famous error and I was asked to write about it by couple of readers. The reason I was not writing about this as the solution of this error…
Read More
SQL SERVER – Database Coding Standards and Guidelines Complete List Download
Download SQL SERVER Database Coding Standards and Guidelines Complete List