Read our high-quality articles on SQL Server development. Learn how to efficiently develop data processes in the world’s biggest DBMS, that is SQL Server.
In this article, we will be discussing about Table-Valued Parameters (TVPs) in SQL Server 2008 and later. Support of Table-Valued Parameters is another great new feature in SQL Server 2008 and later. I am sure that all of us had to make a stored procedure or function call in SQL Server many times. In the … Read more…
In this article, we will compare DATETIME2 vs DATETIME in SQL Server, discuss about their precision and see some examples. About DATETIME2 in SQL Server The DATETIME2 is a data type in SQL Server, that was originally included in SQL Server 2008. We all know of the existence of the DATETIME. So, what is … Read more…
Similarly to my previous post about the DATE data type in SQL Server 2008 and later, another data type, which was originally shipped in SQL Server 2008 is the “TIME” data type. Again, without having to manipulate the current datetime for getting the time, you just have to cast it to the TIME data type. … Read more…
One of the new data types originally shipped with SQL Server 2008 is the “DATE” data type. The DATE data type provides only the date without requiring from the database developers to extract the date from the datetime anymore. To this end you can just get the date with a single line of code: SELECT … Read more…
In this article, we will be discussing about, the MERGE Statement in SQL Server. The MERGE Statement is a T-SQL enhancement, which was originally shipped with SQL Server 2008. What is the MERGE Statement in SQL Server? So what actually is the MERGE Statement? When and how should it be used? The MERGE Statement … Read more…