Articles by Falguni Thakker
SQL Stored Procedure Explained [Practical Examples]
SQL stored procedures are generally precompiled group of an ordered series of Transact-SQL statements stored into a single logical unit which allow for
35+ SQL Functions Explained in Detail [Practical Examples]
Related Keywords: sql create function, sql functions example, sql function syntax, oracle sql functions, sql functions list pdf, function in sql server, sql …
SQL Transactions Explained [Practical Examples]
SQL Transactions consists of a sequence of SQL statements and/or queries, the SQL standard specifies that a transaction begins implicitly when an SQL
SQL Domain Constraints (NOT NULL, Check, UNIQUE)
Domain constraint is used to restrict the values to be inserted in the column or relation, domain constraint defines a valid set of values for a table
SQL TOP Explained [Practical Examples]
SQL TOP clause is used to limit the records returned as the result set of SQL select query by specified number of rows or percentage of rows in SQL Server.
SQL FULL OUTER JOIN Explained [Practical Examples]
Examples to use SQL Full Outer Join with two tables, three tables, multiple tables with Where Clause, multiple tables with Group by Clause, Using Union Clause, …
SQL RIGHT OUTER JOIN Explained [Practical Examples]
SQL RIGHT OUTER JOIN is one type of SQL OUTER JOIN used to retrieve all records from the right table of the join and match records from the left table side of …
SQL Exists Explained in Detail [Practical Examples]
We have covered the overview of the SQL Exists operator, define the use of SQL Exists, Syntax of how to use SQL Exist with an explanation of each syntax …
SQL LIMIT Usage Explained [Practical Examples]
We have covered practical examples of SQL LIMIT starts with simple example LIMIT with number of rows , order by clause, left outer join , where clause
SQL CONTAINS Explained [Practical examples]
we have covered the SQL Contains which is used to do the searching operation for a word or phrase or nearby word on a full-text index, we have started with an …
How to PROPERLY add comments in SQL [Multiple Ways]
We will cover different practical examples to explain how to add SQL comments for Single line comments, Multi-line comments, Inline comments
SQL OUTER JOIN Explained [Practical examples]
SQL OUTER JOIN is used to preserve all of the records that have values in either the left or right table, In the SQL OUTER JOIN all the content of both tables …
SQL INSERT INTO SELECT with Practical Examples
This article of SQL INSERT INTO SELECT, the article begins with the overview of SQL INSERT INTO SELECT with syntax, use of each syntax argument and clause, the …
Delete table in SQL / DROP TABLE in SQL [Practical Examples]
In this article of delete table in SQL, we have covered the delete table command DROP TABLE used to delete a table in SQL with syntax and explanation of each …
How to alter table and add column SQL [Practical Examples]
In SQL, to add column(s) to the existing table SQL ALTER TABLE ADD statement is used, there is no statement like SQL ADD COLUMN to add the column or to modify …