Introduction: A collection of SQL statements is referred to as a stored procedure in SQL and is stored together in a database. It can execute
Category: SQL Server
Dynamic SQL – Export Data
As specified in the previous post, the method we use to write SQL queries so that they are dynamically built alongside application actions is known
Error Handling – RAISERROR
In my earlier essay, I discussed SQL Server’s error handling in great detail. This is a follow-up post; it discusses RAISERROR, which produces an error
Error Handling – Introduction
In SQL Server, error handling (also known as exception handling) offers us control over the Transact-SQL code and aids in diagnosing the precise point where
Using a User Defined Function while adding a column
I tried to figure out how to add the computation expression for a computed column using a user-defined function that I discovered while visiting an
Can we alter the computed column in SQL Server
Can we alter a computed column in SQL Server? The answer is- NO. A calculated column is basically a virtual column that isn’t physically stored
Big Data & SQL 