Category: SQL Server

DIFFERENCE BETWEEN INNER JOIN ,LEFT JOIN AND FULL JOIN-SQL Table SQL Script Now let’s execute this query and see the output that we notice that student name and University name and … Read More

BEST SQL SERVER QUERY WITH PAGINATION AND COUNT if you are using MSSQL 2012 or the latest version, then you can use Offset and Fetch which is the best way … Read More

HOW TO UPDATE A TABLE USING JOIN IN SQL SERVER ? Generic Syntext Query: As you can see in the below image , I have created two table Company_Employees and Department.Company_Employees has a foreign … Read More

FIND RECORDS FROM ONE TABLE WHICH DON’T EXIST IN ANOTHER SQL  We will learn, How to select all records from one table that do not exist in another table using the … Read More

ADDING A COLUMN WITH A DEFAULT VALUE TO AN EXISTING TABLE IN SQL SERVER  We will learn, How to Add a column with a default value to an existing table in … Read More