Service broker is a framework that helps applications to exchange messages that contain the information required to complete the task. It was intoduced in MSSQL… Read More
Tag Archives: SQL-Server
Given a column in the table having strings with comma-separated values. The task is to split all the comma-separated values and insert them as new… Read More
Given a string with digits and characters. The task is to find the sum of digits in that string. So, let’s start by creating a… Read More
In SQL, sometimes we need to find frequent values in a column. For this we use a following steps. So, let’s start by creating a… Read More
In SQL Server, a multi-statement table-valued function (TVF) is a user-defined function that returns a table of rows and columns. Unlike a scalar function, which… Read More
The ROW_NUMBER() function is a type of window function that could be used in SQL Server to assign a successive number to each row within… Read More
There are multiple ways to find a day name from a date in SQL Server. Below we will a few methods to find the day… Read More
An Input Parameter can influence the subset of rows it returns from a select statement within it. A calling script can get the value of… Read More
Pre-requisites: Audit Trail In today’s world, data plays a vital role for any organization. Not just for the organization but also for customers. It becomes… Read More
Transact SQL Statements can be classified into DDL, DML, and DCL Statements and in terms of Computer Programming, DML statements can be referred to as… Read More
RANDOM( ) in SQL is generally used to return a random row from a table present in the database. Here we will see, how to… Read More
Microsoft Azure provides us with multiple database services which help us to run popular relational database management systems, like MySQL, SQL Server, and PostgreSQL in… Read More
SQL Server is very popular in Relational Database and it is used across many software industries. In MS SQL Server, two sorts of databases are… Read More
In this article, we are going to learn a SQL Query to convert data in Datetime data type to data in Epoch datatype. So, Epoch… Read More
In this article, we will be looking at how to save results with headers in SQL server management studio. We will be first creating a… Read More
