What are the benefit or uses of view?
What are the benefit or uses of view?
Uncategorized
What is a view in SQL Server ? How to create one.
What is a view in SQL Server ? How to create one.
What is Identity?
What is Identity in SQL Server?
What are the differences between DDL, DML and DCL in SQL?
What are the differences between DDL, DML and DCL in SQL?
What is database normalization?
What is database normalization?
What is SQL?
What is SQL?
What is the difference between primary key and unique constraints?
What is the difference between primary key and unique constraints?
What are super, primary, candidate and foreign keys?
A super key is a set of attributes of a relation schema upon which all attributes of the schema are functionally dependent. No two rows can have the same value of super key attributes. A Candidate key is minimal super key, i.e., no proper subset of Candidate key attributes can be a super key. A …
What are super, primary, candidate and foreign keys? Read More »
What is the difference between a “Local Temporary Table” and “Global Temporary Table”?
What is the difference between a “Local Temporary Table” and “Global Temporary Table”?
What is the difference between “Primary Key” and “Unique Key”?
1. We can have only one Primary Key in a table whereas we can have more than one Unique Key in a table.2. The Primary Key cannot have a NULL value whereas a Unique Key may have only one null value.3. By default, a Primary Key is a Clustered Index whereas by default, a Unique …
What is the difference between “Primary Key” and “Unique Key”? Read More »