Top 100 SQL server queries Interview questions | SQL server interview questions
Introduction In this article, you will find basic to most puzzled interview queries questions with an example. This article is …
sqlserver
sqlserver
How to find out Microsoft SQL Server Enterprise Edition Expiration Date
Introduction As you all know Microsoft SQL Server’s evaluation edition expires after 6 months of validity. So in this article, …
How can I remove duplicate rows from large table
Introduction Remove duplicate rows from large table which has more than 10,000+ rows. DELETE FROM student WHERE ID NOT IN …
Write a SQL query to get FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for all students even if they didn’t get Scolarship
Introduction Write a SQL query to get FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for all students even …
SQL Server Advanced Questions – ‘Join’
The following exercise will help you to improve your MS SQL server query skills effectively. I have used Microsoft SQL …
