The given content provides three techniques for generating unique numbers in SQL Server. The first approach is to use an identity column, which automatically assigns a unique number to each row ins...

In this blog, you will learn about sessions in SQL Server.

In this blog, you will learn about SQL Database MDF and LDF.

In this blog, we can calculate the self-value calculation in SQL.

In this blog, we learn how to calculate credit debit Transactions like banking report using SQL Sever.

In this blog create auto folder & auto backup using Xp_Cmdshell.

Search views, and stored procedures in a database with a specific name

in this blog, we can find the same name parameter used in procedure, we can get store procedure list by using DMV.

in this blog, find any content from procedure to checking the impacted procedure list.

in this SQL Script we learn & Prepare SQL Query for compare Source & Target Database

We learn about sequence in SQL for Generating unique Number as per requirement Ex : Account Number (SBank_100001)

In this blog, we learn about SQL dynamic Table Partition.

in this blog we learn how to use merge in SQL for Insert, update & delete Record as per merge conditionally for bult insert, update & delete bulk records From Source Table To Target Table

in this blog, we learn about calling store procedure in select Statement like Table.

In this blog, we learn to call a Web API from SQL server.

In this blog, we learn about how to tune Database & Tables by using SSMS Profile & SSMS Database tuning advisor.

In this article we learn about convert complex json data to sql table in easy steps

In this blog, you will learn about bulk data Insertion in SQL Table using Union ALL.

Let's learn about the Logical operators with detailed examples in SQL Programming.

Search procedures on the basic of a column name. You can search only in Stored procedure and All objects as well. So, added 2 queries for the same.