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 – 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 – Database Coding Standards and Guidelines Complete List Download
Download SQL SERVER Database Coding Standards and Guidelines Complete List
SQL SERVER – Database Coding Standards and Guidelines – Part 2
SQL Server Database Coding Standards and Guidelines – Part 2
SQL SERVER – Database Coding Standards and Guidelines – Part 1
SQL Server Database Coding Standards and Guidelines – Part 1
SQL SERVER – Database Coding Standards and Guidelines – Introduction
I have received many many request to do another series since my series SQL Server Interview Questions and Answers Complete List Download. I have created small series of Coding Standards and Guidelines, as this is the second most request I have received from readers. This document can be extremely long but I have limited to very few pages as it is difficult to follow thousands of the rules. My experience says it is more productive developer and better code if coding standard has important fewer rules than lots of micro rules.