SQL Articles
  • Dotnet Articles
  • My Diet
  • My Paintings
  • My Favorite Quotes
  • About
  • Contact

SQL Articles


SQL SERVER Ranking Functions - RANK, DENSE_RANK, NTILE, ROW_NUMBER

SQL query to delete duplicate rows

SQL Server Isolation Levels with examples

SQL query to update from join

SQL Server CTE(Common Table Expression) and Recursive Queries

CTE Recursive query for data hierarchy(Parent Child hierarchy)

Different methods of SQL queries to insert data in tables

SQL query to display all columns with datatypes for a given Table name

SQL query to check two tables have identical data

SQL query to search a string in database Schema

SQL query to display total number of rows for each table in database

SQL query to search a column name in all tables

SQL server query to search object name in database

SQL Server performance tip - Do not use NOT IN clause in Subquery use LEFT OUTER JOIN instead

About me