Results for "sql-server"
50 / 184 posts
What is the difference between DELETE and TRUNCATE statements in SQL?
--What is the difference between DELETE and TRUNCATE statements in SQL? --DELETE and TRUNCATE are both SQL commands that can be used to remove data from a …
Added columns in a table by dynamic ways
IF OBJECT_ID('AddedDynamicColumn','P') IS NOT NULL BEGIN DROP PROC AddedDynamicColumn END GO CREATE PROCEDURE AddedDynamicColumn AS BEGIN SELECT ED.empid,E…
How to get first date of given date or month.
Get First date of month: SELECT DATEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), 1) AS FirstDayOfCurrentMonth Create function for that IF NOT EXISTS (SELEC…
How to one series with comma separate(any Delimiter) value split into in rows
If we have one series with comma separate(any Delimiter) value and we want split into in rows, I have create function for that: IF OBJECT_ID('TF_SplitSerie…
How to Two series with comma separate(any Delimiter) value split into in rows respectively
If we have two series with comma separate(any Delimiter) value and we want split into in rows, I have create function for that: IF OBJECT_ID('TF_SplitTwoSe…
Use of Apply(Cross and Outer) operator in SQL server
APPLY operator joins two table expressions. Also, I'll show how it differs from regular JOINs. Operator: CROSS APPLY Similar: INNER JOIN When to Use: Use a…
How to use GOTO statement in SQL server
If you want to jump to a specific point in your SQL code, you can use the GOTO statement. The GOTO statement is used to exit a loop or a nested block of co…
How to use Magic (virtual) table INSERTED and DELETED in SQL server
Magic Tables are virtual tables that are automatically created and maintained by SQL Server for each data modification operation performed on a table. They…
How to find table column information by using SQL query
Comprehensive Guide to Fetching Table and Column Metadata with SQL Server Stored Procedures When working with databases, understanding the structure of tab…
UNION, UNION All, INTERSECT, EXCEPT used in SQL Server
UNION : The UNION operator is used to combine the result sets of two or more SELECT statements into a single result set. It removes duplicate rows from the…
What is an Index? Explain its different types in SQL
✅ Index in SQL Server (इंडेक्स इन SQL सर्वर): Index SQL Server में एक database object (डेटाबेस ऑब्जेक्ट) है जो टेबल के डेटा को जल्दी से प्राप्त करने के लिए…
What is View in SQL server
A view is a virtual table based on the result-set of an SQL statement. A view contains rows and columns, just like a real table. IF OBJECT_ID('ViewTable','…
Normalization in Databases
Normalization in a database is the process of organizing the data to reduce redundancy and improve data integrity. The main goal of normalization is to bre…
Triggers in SQL server
A trigger in SQL is a special type of stored procedure that runs automatically when certain actions happen in a table or view . A trigger cannot be explici…
SQL Server Data type
SQL Server provides a variety of data types to store different kinds of data efficiently. Here are some commonly used SQL Server data types: CHAR(size): A …
Window Aggregate Functions in SQL
What is window function: Imagine you have a dataset with many rows, and you want to perform some calculations on each row based on a group of rows related …
Implementing Transactions,Error Handling, and Dynamic SQL in SQL
Think of a transaction as a complete package deal. It's like when you buy something from a store. You give them money, and in return, you expect to get the…
WAITFOR in sql server
The WAITFOR statement in SQL Server is used to introduce a delay or wait period in the execution of a batch, transaction, or query. WAITFOR DELAY '00:00:05…
What are Constraints in SQL?
SQL में constraints डेटाबेस टेबल में डेटा को सुरक्षित और सही बनाए रखने के लिए उपयोग किए जाते हैं। ये टेबल में डेटा की वैधता (validity) और अखंडता (integrity…
ANY and ALL operators used in SQL
The ANY operator: returns a boolean value as a result returns TRUE if any of the sub-query values meet the condition Any means that the condition will be t…
Order by index number in SQL
SELECT empid, lastname FROM HR.Employees ORDER BY 1 DESC --order by first column SELECT empid, lastname FROM HR.Employees ORDER BY 2 DESC --order by second…
Logical Query Processing Phases in SQL
SQL query processing consists of several logical phases, which describe the order in which SQL statements are evaluated. These phases help in understanding…
Filtering the data with TOP and OFFSET-FETCH In SQL
TOP: SELECT TOP (5) productid, unitprice FROM Production.Products WHERE categoryid = 1 ORDER BY unitprice DESC; SELECT TOP (5) WITH TIES productid, unitpri…
How to get first date From month and Finyear
If we have Finyear and month then we create a date for examples: DECLARE @finyear CHAR(5) = '202425'; DECLARE @month smallint = 5; --Get Year DECLARE @year…
XML Data – Complete Conceptual Guide (SQL Server Perspective)
How insert data on table from XML in SQL server, example: There are two method for insert data in table from XML. DECLARE @XMLInput VARCHAR(MAX); SET @XMLI…
Insert <br> tag in SQL text string
CREATE or ALTER FUNCTION dbo.Fn_InserBRtag(@inputString NVARCHAR(MAX)) RETURNS NVARCHAR(MAX) AS BEGIN DECLARE @resultString NVARCHAR(MAX) = ''; DECLARE @st…
All Date Components in SQL
We get First Date , Last date ,month number, month Name,Year, Financial Year(Finyear), and Month Year from Date (Date Range of each single date). SET DATEF…
What is Power BI
Power BI is a suite of business analytics tools developed by Microsoft that allows you to visualize and share insights from your data. Power BI consists of…
What is RLS (Row-Level Security) in Power BI
RLS stands for Row-Level Security, which is a feature in Power BI (and also in SQL Server Analysis Services) that allows you to restrict data access at the…
DAX (Data Analysis Expressions) Operators and Data Type in Power BI
Here's the list of DAX operators in a table format: Arithmetic Operators Operator Description Example + Addition = + - Subtraction = - * Multiplication = *…
SYS and INFORMATION_SCHEMA
sys In Microsoft SQL Server, the sys schema is a special schema that contains system views and stored procedures that provide metadata about the SQL Server…
What is cluster in Spark
what is cluster : In computing, a cluster refers to a collection of interconnected computers that work together as a single system . These computers, often…
Split full name into first name and last name in SQL
Split full name into first name and last name : SELECT EmployeeName, CASE WHEN CHARINDEX(' ', EmployeeName) > 0 -- Check if there is a space (indicating…
Pivoting and Unpivoting Data in SQL
Pivoting Data : Pivoting is the process of converting rows of data into columns, effectively changing the orientation of your data. It's useful when you ha…
Store Error Logs In SQL
Create Table for Error log: CREATE TABLE [dbo].[ErrorLog]( [ErrorLogID] [int] IDENTITY(1,1) NOT NULL, [ErrorTime] [datetime] …
What is a SQL Statement and types of SQL statements
A SQL (Structured Query Language) statement is a query or command used to perform various operations on data stored in a relational database. SQL statement…
What is Functions and Difference between Functions and Stored Procedures in SQL Server
What is a Function in sql : A function is a set of SQL Statements that perform a specific task. Basically, it is a set of SQL statements that accept only i…
Database Backup in SQL Server
In SQL Server, taking a database backup is crucial for data recovery and protection. Here’s a basic guide on how to perform a database backup and restore i…
Log Shipping (Ship Log) in SQL Server
Log Shipping in SQL Server is a high-availability feature that allows you to automatically send transaction log backups from a primary database on one serv…
Data archive in SQL Server
A data archive refers to the process of moving inactive or less frequently used data from an operational system to a storage system , typically in a separa…
Database Permissions in SQL Server
In SQL Server, database permissions control what actions users can perform on specific database objects (like tables, views, and stored procedures). Permis…
Index Rebuilding vs. Reorganization in SQL Server
As a database grows, maintaining optimal performance becomes crucial. One of the key contributors to performance degradation over time is index fragmentati…
Understanding Cursors in +SQL Server: A Complete Guide
When working with databases, most SQL operations are designed to handle large sets of data at once. However, there are cases where you may need to process …
Understanding SQL Query for Identifying and Analyzing Default Values and Constraint in a Database
Default constraints in SQL are used to assign a default value to a column when no value is provided during data insertion. However, managing and auditing t…
SQL Interview Q&A
Here are the questions along with their corresponding answers extracted from the provided context: What is SQL? SQL stands for Structured Query Language. I…
Data Import from text/CSV file in SQL Server
Step-by-Step Explanation 1. Checking and Dropping Existing Temporary Tables Before creating the temporary tables, the script ensures that any previously ex…
Understanding Locking Hints in SQL Server: NOLOCK, ROWLOCK, and UPDLOCK
What Are Locking Hints? Locking hints are special options you can include in your SQL queries to tell SQL Server how to handle locks on the data being quer…
DBA
Setting up a lab environment for the course. Option 1 (Limited Resources) : Use a computer, laptop, or workstation with Windows 10 installed. Install SQL S…
Understanding Stored Procedures in MSSQL
What is a Stored Procedure? A stored procedure is a group of SQL statements that are compiled and saved in the database. Instead of writing the same SQL qu…
SQL Server Optimization Q&A
1. What is SQL Server Optimization? Answer: SQL Server Optimization ka matlab hota hai database ka performance better banana — jaise queries fast chalna, k…