Category Archives: Imp SQL Difference

Difference between Stored Procedure and Trigger

Posted on November 1, 2018 by vivekjohari

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

Posted on January 31, 2010 by vivekjohari

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

Posted on January 3, 2010 by vivekjohari

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

Posted on December 22, 2009 by vivekjohari

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

Posted on December 17, 2009 by vivekjohari

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

Posted on October 5, 2009 by vivekjohari

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