Transact-SQL (T-SQL)

There are several ways available in SQL Server to import XML data. Here we will see a simple method to import XML data into SQL Server using SELECT query.

We can store images in SQL Server using few different data types and storage methods. Here we will see couple of common methods.

Solution for the error while creating a table that has FILESTREAM columns. The error was because of missing nonnull unique column with the ROWGUIDCOL property.

By default the FILESTREAM option is disabled in SQL Server. If you want to use it, then you have to enable it first. Follow these steps to enable FILESTREAM.

There are few different ways to replace NULL with 0 in SQL Server. Let us go through them with examples in this article.

To calculate the percentage in an Sql statement, we can use the basic percentage arithmetic formula along with some basic SQL Server functions

While cursors can be useful in certain scenarios, they also come with both advantages and disadvantages. Let’s explore the advantages and disadvantages of cursors.

IIF and CHOOSE are two logical functions in SQL Server used for different purposes. Here we will see the competition of IIF vs CHOOSE.

In this article, we will see how to make an SQL Script to sleep for some time with examples.