SQL Constraints
SQL constraints are set set of rules by which SQL engine enforces the integrity of database. Constraint maintains the standard rules to follow so that integrity in database can be maintained. If there is...
Category: SQL Programming
Use DBCC CHECKIDENT to RESEED Table Identity Columns
316viewsIn many tables we use Identity column to maintain the uniqueness and automatically increment the values when records are inserted. If you want to reset the identity column numbers in a table then we...
SQL CROSS JOIN
SQL CROSS JOIN returns all records where each row from the first table is combined with each row of the second table. CROSS JOIN returns the Cartesian product of the tables involved in join if...
SQL FULL JOIN
SQL FULL JOIN returns all the rows from the left table and all the rows from the right table. If there are no matching values in either of the tables then non-matching values returned as NULL....
SQL RIGHT JOIN
SQL RIGHT JOIN returns all the rows from the right table mentioned with the RIGHT JOIN clause. If there are no matching rows in left table then output rows will return NULL values. Syntax SELECT...
SQL LEFT JOIN
SQL LEFT JOIN returns all the rows from the left table mentioned with the LEFT JOIN clause. If there are no matching rows in right table then output rows will return NULL values. Syntax SELECT...
