Many articles have been written to describe the difference between the SQL DELETE and SQL TRUNCATE statements. Moreover, it is one of the most common questions during job interviews. Both statements remove the data from the table. However, there are differences too. This article will focus on ...
Alias column with variable value in SQL Script All MonthNames and Month numbers in sql server All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists. all the events in the workload were ignored due to syntax errors.the ...
SQL SERVER – Simple Script to Create a Login and User for a Specific Database with System Admin RightsA very popular question I often receive about SQL Server security is what is the difference between SQL Server Login and SQL Server User. I really love this question as I bet only 5% of...
In this article, I am going to explain the difference between Inner join and full join with examples. This is one of the very common SQL server interview questions. Here we will be using SQL Server 2017 or you can use SQL Server 2008 or above. Read my previous Joins in SQL Server 2017...
Difference between HTMLEncode & JavaScriptEncode Difference between input type BUTTON and SUBMIT difference between location.href and Response.Redirect Difference between MemoryStream.WriteTo and Response.Outputstream.Write while building a CSV Difference between Web Server control and HTML Server control ...
Let us see the output of the preceding script.We can we have two input strings. The first string has the expression without any trailing space. So it is equivalent to Len() function in this scenario. But when we add a trailing space to the input function it counts the space as well....
Now we will see thedifference between the HAVING and WHERE clauseon various points. Conclusion As you can see both WHERE and HAVING are used in different scenarios. You can use both in a SQL query as and when required for writing the desired logic. Both are an integral part of any SQL ...
In SQL Server, both the SEQUENCE object and IDENTITY property are used to generate a sequence of numeric values in an ascending order. However, there are several differences between the IDENTITY property and SEQUENCE object. In this article, we will look at these differences. Difference 1: The...
But before, let's have look into the basics of views and materialized view individually for better understanding of the differences between them. Views in SQL Views are the logical and virtual copy of a table that is created by executing a "SELECT query" statement. The views are not stored...
In addition to theSQL differences view, SQL Compare's summary view provides are more succinct view of the differences between two database objects. Rather than showing the full SQL creation script for each object, the summary view shows only the differences between two objects in a structured hi...