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…
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…
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…
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…
Sql Server – Union and Union All
Union and Union All, both are used to select data from one or more than one tables but still they…
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…