The Perfect Mix of Technology & Knowledge
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 … Read more
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) … Read more
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 … Read more
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 … Read more
Union and Union All, both are used to select data from one or more than one tables but still they have some differences. For Example, Union is used to select distinct data from the tables but Union All allows duplicate rows to be selected from the tables. Suppose we have a table called tbl_Manager and … Read more
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 … Read more
