Reset Identity column value
An identity column in table generates key values automatically based on the current seed and increment, and the benefit of creating an identity column is… Read More »Reset Identity column value
69 total views
SQL Server Tutorials| Basics & Advance Concepts | Interview Question & Answer Series | SQL Server Tricks & Tips
An identity column in table generates key values automatically based on the current seed and increment, and the benefit of creating an identity column is… Read More »Reset Identity column value
69 total views
This article demonstrate how to replace multiple columns value at once in Power Query. Lets say, you need to check if column value is blank… Read More »Replace multiple columns values in Power Query
142 total views
The SQL NOT EXISTS Operator is used to check the existence of any record in a subquery. The NOT EXISTS operator returns true if the… Read More »SQL NOT EXISTS
271 total views, 1 views today
Write an SQL query to report the nthย highest salary from the Employee table. If there is no nthย highest salary, the query should report null. Table:… Read More »SQL Leet Code Nth Highest Salary Problem
336 total views
SQL Leet code problem: Rank Scores Write an SQL query to rank the scores. The ranking should be calculated according to the following rules: The… Read More »SQL Leet Code Rank Scores Problem
357 total views
You can convert multiple rows into a single comma separated row, it can done by multiple ways using inbuilt SQL functions. As you can see… Read More »How to get multiple row data in single row in SQL
3,884 total views, 5 views today
Rolling average is a calculation to analyze data by creating series of average of different subsets of the entire data. For example, you have data… Read More »Rolling average in SQL
1,781 total views, 2 views today
To find the highest salary of employee in each department, first we will create a sample tables named EmployeeDetails and Department as shown below. CREATE… Read More »How to get top salary of each department
4,992 total views
There are multiple ways to get the size of table in SQL Server. Lets take a look on them one by one. Using sp_spaceused system… Read More »How to get the size of table in SQL
5,372 total views
Sometimes you need to insert same row multiple times in a table. There are many ways to do that but here we will see one… Read More »Insert same rows multiple times in table
6,166 total views
In this article you will see how to compare column names in two table. Assume that, you have two tables and you are asked to… Read More »How to compare column names in two tables in SQL
10,974 total views, 3 views today
You may have faced a situation where you are asked to find values in a column with leading or trailing spaces or remove the leading… Read More »How to find leading and trailing spaces in SQL Server ?
4,459 total views
Showing a last refresh date and time in Power BI report let you know how fresh your report data is as sometimes report viewer can… Read More »How to show last refresh date in Power BI
4,433 total views
How to search for string within xml column in SQL table? As you can see here we have a sample table having categories and products… Read More »Search string in xml
2,740 total views
Sometimes, you need to show range of numbers or may be asked to generate a range of numbers between two numbers in SQL Server. Well,… Read More »Generate a range of numbers between two numbers in SQL Server
9,502 total views
A lost update problem occurs in concurrent transactions, when two transactions try to read and update the same column on the same row within a… Read More »Lost update problem in concurrent transations
4,168 total views
SQL Return is a control-of-flow language keyword which is used to exit unconditionally from a query or stored procedure. It can be used at any… Read More »SQL Return
1,074 total views
As a SQL Server developer you must know some keyboard shortcuts while working on SQL Server Management Studio, although it is not necessary to know… Read More »SSMS keyboard shortcuts
3,395 total views, 2 views today
Sometimes you need to export data from SQL Server tables, views or the result of any T-SQL query into excel file, reason could be anything… Read More »Export data from SQL Server to an Excel file
2,318 total views
Date data type allows you to store the date data in the database. It takes 3 bytes to store a date value. SYNTAX date The… Read More »SQL Server Date
1,327 total views