SQL Server Authentication is a default way to connect to MS SQL Server, but there may be many times that you need to use SQL Server Authentication to connect to…
In this post we’ll discuss SQL server “Set Transaction Isolation Level”. These are of 5 types, and we’ll discuss all one by one below. READ UNCOMMITTED Read uncommitted specifies that…
In this post we’ll read about the use of [Nolock] in SQL Queries and stored procedures. Is this good or bad practice to use this in query. Let’s check out…
In this article we will learn about SQL Paging using OFFSET and FETCH. In SQL these clauses can be used with ORDER BY to limit the number of rows returned…
In this we will discuss about ‘aggregate and summarize totals with SQL SUM function. Knowing the method to calculate the complete addition of a specified column in a SQL Server…
In this article we will learn how to use SQL ORDER BY in your queries. SQL is a powerful tool for manipulating data and ordering results in a specific order.…
In this article we will learn how to take SQL server database offline/online. There are some situations when we need to offline the database like How to make your DB…
In this article we’ll learn how to generate SQL table script with data. You can create insert script of table before playing with its data for the safer side so…
In this article we’ll learn about SQL server Column encryption using Symmetric key. In Financial organizations or banks, we have sensitive data including account numbers and credit card numbers. As…
In this article, we will learn how to UPDATE using a SELECT statement in SQL Server. There are “multiple ways which are used to update the data in a given…