Tag: SQL

Delete duplicate rows from SQL table

Delete duplicate rows from SQL table. How to delete duplicate rows without a primary key? Select only unique rows using CTE.  For the demonstration purpose, I have created a dummy database […]

Let’s understand the Transact-SQL

T-SQL or Transact-SQL is a proprietary SQL extension (design query language). Additional features include high performance, maximum functionality, and greater globalization support. Transaction SQL is a Microsoft SQL Server process […]

SQL interview questions part 1

What is SQL function? SQL functions are methods which accept parameters and perform the action, such as a complex calculation and return the result of that action as a value.the […]

Alternatives ORM for Entity Framework

Entity Framework has come a long way since version 1. So much that it leapfrogged every other version up to version 7. With EF Core 2 out, I feel this gives […]