User-Defined Data Types In SQL Server
SQL Server platform comes with many data types, but there are cases when they are not sufficient....
Varchar To Date Conversions In SQL Server
Introduction In many scenarios, date and time information is loaded and stored in the text format. Converting these values to the date/time...
SQL Server JSON – Part 2
Introduction In the previous article, we covered the basics of JSON and showed how to use JSON in SQL Server, demonstrating these concepts...
SQL Server User-defined Functions
User-defined functions in SQL Server (UDFs) are key objects that each developer should be aware of....
JSON for SQL Server. Part 1
In the last few years, JSON has positioned itself as a standard data exchange format between services, although XML is still widely used....
Execute Dynamic Query in SQL Server
Dynamic SQL is a statement constructed and executed at runtime, usually containing dynamically generated SQL string parts, input...
Storing Binary Data Types in SQL Server
Introduction Daily work rarely requires storing binary data directly to database columns. However,...
Implementing Error and Transactions Handling in SQL Server
Introduction No matter how hard we try to design and develop applications, errors will always occur. There are two general categories –...
How to Use Array Functionality in SQL Server
Have you ever been asked how to create array in SQL Server? Or, you might be asked how to how to store values in an array in SQL Server....