Imp SQL Difference Archives - Technology with Vivek Johari

Difference between Stored Procedure and Trigger

November 1, 2018 vivekjohari15 Comments

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 specific task. Trigger are also similar to SQL Stored procedure as they can also be a […]

Difference Between Having and Where Clause in Sql Server

January 31, 2010February 1, 2019 vivekjohari39 Comments

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 Having clause we will going to use the table EmployeeDeptInfo whose create query statement is […]

Difference between Clustered Index and Non clustered Index

January 3, 2010February 1, 2019 vivekjohari31 Comments

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 particular record. In Sql Server there are two types of Index 1) Clustered Index 2) […]

Sql Server- Difference between Stored Procedure and Function

December 22, 2009February 1, 2019 vivekjohari6 Comments

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 follows:- 1) A stored procedure can return a value or it may not return any […]

Difference between Delete and Truncate Command

December 17, 2009February 1, 2019 vivekjohari1 Comment

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 each deleted row but Truncate command do not maintain the logs files for each deleted […]

Difference between Primary key and Unique key

October 5, 2009February 1, 2019 vivekjohari30 Comments

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 they are defined but still there are some differences between them. The differences are defined […]