Understanding Questions For SQL Server & SQL Server Management Studio Part II


Primary Key :

  • A primary key is a field in a table which uniquely identifies each row/record in a database table. 

  • Primary keys must contain unique values.


Explain What is a Identity Column ?

  • Identity column of a table is a column whose value increases automatically. 

  • The value in an identity column is created by the server. 

  • A user generally cannot insert a value into an identity column.

  • Identity column can be used to uniquely identify the rows in the table.


How can I create One to Many relationship ?

  • In a one-to-many relationship, one record in a table can be associated with one or more records in another table.

How can I create Primary Key & Foreign Key relationship ?

  • In a foreign key reference, a link is created between two tables when the column or columns that hold the primary key value for one table are referenced by the column or columns in another table. 

  • This column becomes a foreign key in the second table.


Are NULLs allowed in Foreign Key ?

  • Yes, it can be NULL. 

  • A Foreign key simply requires that the value in that field must exist first in a different table. 

  • Null by definition is not a value.


How can we create Composite Key ?

  • Composite key is a key which is the combination of more than one field or column of a given table.


How to write a simple SQL with Where Clause ?

  • The WHERE clause is used to filter records.

  • It is used to extract only those records that fulfill a specified condition.

How to Select specific Column in Select ?

  • The column names that follow the select keyword determine which columns will be returned in the results.


What is an ALIAS in SQL ?

  • SQL aliases are used to give a temporary name.

  • An alias is created with the AS keyword.


Explain the Difference between Inner vs Left vs Right ?

  • INNER JOIN : Returns records that have matching values in both tables.

  • LEFT JOIN : Returns all records from the left table, and the matched records from the right table.

  • RIGHT JOIN : Returns all records from the right table, and the matched records from the left table.

Comments

Post a Comment

Popular posts from this blog

Basic Concept In C Sharp Day 16

Image
Lecture 16 : Basic Concept In C Sharp C Sharp : C#  (pronounced  see sharp , like the musical note C♯, but written with the number sign) is a general-purpose, multi-paradigm programming language encompassing static typing, strong typing, lexically scoped, imperative, declarative, functional, generic, object-oriented (class-based), and component-oriented programming disciplines. C# was developed around 2000 by Microsoft as part of its .NET initiative and later approved as an international standard by Ecma (ECMA-334) in 2002 and ISO (ISO/IEC 23270) in 2003. It was designed by Anders Hejlsberg, and its development team is currently led by Mads Torgersen, being one of the programming languages designed for the Common Language Infrastructure (CLI). The most recent version is 9.0, which was released in 2020 in .NET 5.0 and included in Visual S...
Read more

Concept Of TypeScript Day 8

Image
Lecture 8 : Concept Of TypeScript What is TypeScript : TypeScript is a strongly typed, object oriented, compiled language.  “TypeScript is JavaScript for application-scale development.” TypeScript is both a language and a set of tools. TypeScript is a typed superset of JavaScript compiled to JavaScript. History of TypeScript : In 2010, Anders Hejlsberg , a core member of the development team of C# language, started working on TypeScript at Microsoft.  The first version of TypeScript was released to the public in the month of 1st October 2012, and was labeled as version 0.8. Now, it is maintained by Microsoft under the Apache 2 license.  The latest version of Typescript is TypeScript 3.5, which was released to the public on May 2019. Features of TypeScript : TypeScript is just JavaScript : TypeScript starts with JavaScript and ends with JavaScript. Typescript adopts the basic building blocks of your program from JavaScript. Hence, yo...
Read more

Understanding C Sharp Day 18

Image
Lecture 18 : Understanding C Sharp   Class Library : A class library  defines types and methods that are called by an application. The  Class Library .DLL  contains program code, data, and resources that can be can used by other programs and are easily implemented into other Visual Studio projects. Create New Class Library Project with Visual Studio :  Create New Project : Select C# in the language tab And then select  Class Library (.NET Framework) and press the NEXT button You can then proceed to give your project a Project Name Call the project  MathLibrary  (in order to copy/paste example code) Press the CREATE button, After you have given a name to your project Building the Class Library .DDL for C# : The following code example is a C# version of the Class Library.  The Class Library .DLL contains program code, data, and resources.  The Class Library in this example will feature a cus...
Read more