Category Archives: Imp SQL Difference

Difference between Stored Procedure and Trigger

Difference between Stored Procedure and Trigger     SQL Stored Procedure & SQL Triggers, both are the important objects of SQL. SQL stored procedure are the set of logically group of SQL statements which are a group to perform a … Continue reading

Posted in Imp SQL Difference, SQL Server, SQL Stored Procedure | Tagged , , , | 15 Comments

Difference Between Having and Where Clause in Sql Server

Both Having Clause and Where clause is used to filter the data coming from the Select statement, but still there are some differences between them. These difference are given below:- To show the difference between the Where Clause and the … Continue reading

Posted in Imp SQL Difference, Interview Questions, SQL Group By Having, SQL Server | Tagged | 39 Comments

Difference between Clustered Index and Non clustered Index

Indexes-Indexing  is way to sort and search records in the table. It will improve the speed of locating and retrieval of records from the table.It can be compared with the index which we use in the book to search a … Continue reading

Posted in Imp SQL Difference, Interview Questions, SQL Indexes, SQL Server | Tagged , , | 31 Comments

Sql Server- Difference between Stored Procedure and Function

In Sql Server, both functions and stored procedures can be defined as the logically grouping of Sql statements formed to complete a task, but still there are many differences between Stored procedure and Functions. These differences can be summarized as … Continue reading

Posted in Imp SQL Difference, Interview Questions, SQL Functions, SQL Server, SQL Stored Procedure | Tagged | 6 Comments

Difference between Delete and Truncate Command

Although the Delete and Truncate Commands logically does the same work of deleting the rows from the table but still there are many differences in their working. These differences are given below:- 1) Delete command maintained the logs files of … Continue reading

Posted in Imp SQL Difference, Interview Questions, SQL Basic Concepts, SQL Server | Tagged | 1 Comment

Difference between Primary key and Unique key

var gaJsHost = ((“https:” == document.location.protocol) ? “https://ssl.” : “http://www.”); document.write(unescape(“%3Cscript src=’” + gaJsHost + “google-analytics.com/ga.js’ type=’text/javascript’%3E%3C/script%3E”)); try { var pageTracker = _gat._getTracker(“UA-11608194-1”); pageTracker._trackPageview(); } catch(err) {} Both Primary key and Unique key enforce uniqueness of the column on which … Continue reading

Posted in Imp SQL Difference, Interview Questions, SQL Primary Key Constraint, SQL Server | Tagged | 30 Comments