How to get day of week in Sql Server

There are certain cases where you need to get the the name of the week number or name. On Sql Server we have some functions that can help us. You can check the following functions that can help with this task. Datename This function returns … “How to get day of week in Sql Server”

Read More

How to zip files in azure data factory

In this tutorial, I am going to zip files in azure data factory. For going through the tutorial, we are going to create some files and move them into a blob storage. For completing the task, please follow the next steps. Steps to zip files … “How to zip files in azure data factory”

Read More

How to Update top N records in Sql Server

A typical sql server update consist in updating a set of data filtered by the where clause but sometimes we only need to update the top N records without affecting the others. Dataset We are going to use ‘Sales.Customers’ table from WideWorldImporters database. Next, we … “How to Update top N records in Sql Server”

Read More

How to alter a column from null to not null in sql server

Changing a column from NULL to NOT NULL consist in making a change on the table by using ALTER TABLE syntax. There are few steps that you have to follow in order to change a column from null to not null. Check the column to … “How to alter a column from null to not null in sql server”

Read More

How to escape square brackets in a like clause in sql server

This is a common issue that you find when you try to look for brackets or other wildcard characters using LIKE sentence in Sql Server. All of these wildcards work on a different way when invoking them into a LIKE sentence, You can check them … “How to escape square brackets in a like clause in sql server”

Read More