Understanding of SQL JOIN with Examples SQL JOIN :- SQL Join is used to combine data or row from two or more tables based upon common field between them. Different Type of Joins:-  Below are the list of Joins in SQL 1) Inner Join 2) Left Join 3) Right Join 4…

SQL Tutorials

DotNetTechnologiesTutorials

SQL Table Operations: Table is a collection of data organized in term of rows and columns or you can say table has row and column which contain the data. Below are the list of operations which can be perform on SQL database. CREATE Table DROP Table DELETE Tab…

SQL Tutorials

DotNetTechnologiesTutorials

SQL Database Operations:- Below are the list of operations which can be perform on SQL database. 1- Create Database 2- Drop Database 3- Rename Database  4- Select Database 5- Backup Database.      1. Create Database :- The " CREATE DATABASE " state…

SQL Tutorials

DotNetTechnologiesTutorials

SQL Operators : SQL operators are reserved keywords used in the WHERE clause of a SQL statement to perform arithmetic, logical and comparison operations.  Operators act as conjunctions in SQL statements to fulfill multiple conditions in a statement.  Type of…

SQL Tutorials

DotNetTechnologiesTutorials

SQL Data Types:- Each column in database table must have column name and datatypes. SQL Datatypes on column defines what type of data column can hold. Example : Integer, date, character, time , etc. Type of SQL datatype:-  Numeric data types Character data t…

SQL Tutorials

DotNetTechnologiesTutorials

## Introduction to SQL SQL stands for Structure Query Language  SQL is standard language for storing, Manipulating(updating), retrieving data from database. You can use SQL syntax in below list of database. MySQL SQL Server Oracle MS access PostGreySQL sybase…

SQL Tutorials

DotNetTechnologiesTutorials

C# Interview Question and Answer  1- What is C# ? C# is a Simple, Modern, General-purpose, object-oriented programing Language developed by Microsoft. it is a type safe and Managed language that is compiled by Roslyn .NET Compiler to generate Microsoft inter…

C# Tutorials

DotNetTechnologiesTutorials

C# Fundamentals  1-C# Versions till Date - 2-Create a Console Program in C# and Understand the sytax. 3-Classes in C# 4-Namespace in C# 5-Variables in C# 6-Datatype in C# 7-Operator in C# 8-Condition and Loops in C# 9-Collection in C# 10-Exception Handling 1…

C# Tutorials

DotNetTechnologiesTutorials

Question 1 :  If table A has 10 records and Table B has 5 Records and if we perform a Cross Join then how many records will be return ? Answer : There will be 50 records will be return on cross join on table. because cross join perform Cartesian join where ea…

SQL Interview Question

DotNetTechnologiesTutorials

What is Difference Between Clustered Index and Non-Clustered Index ? Clustered Index :  Clustered Index are used to arrange the data in sorted Order. There will be only one Clustered Index created on SQL Table. Clustered Index are faster than Non-Clustered I…

SQL Interview Question

DotNetTechnologiesTutorials

What is Index and Type of Index in SQL Database ?  Definition : Index are used to make SQL query faster.  Syntax : Create Index   statement is used to create Index in table. CREATE INDEX [INX_INDEX_NAME] ON TABLE_NAME (COLUMN NAME, COLUMN NAME......); Examp…

SQL Interview Question

DotNetTechnologiesTutorials

1.   How to create empty tables with the same structure as another table ? 2.   What are difference between DROP and TRUNCATE in SQL ? 3.   What is difference between Delete and truncate? 4.  What is Normalisation and denormalisation? What is subquery and typ…

SQL Interview Question

DotNetTechnologiesTutorials

How to create empty tables with the same structure as another table ? To Create Empty blank structure table , we can use INTO keywords, refer to syntax below, Select * Into <DestinationTableName> From <SourceTableName> Where 1 = 2 Note that this …

SQL Interview Question

DotNetTechnologiesTutorials

What are difference between DROP and TRUNCATE in SQL ?  DROP :  The DROP command is used to remove table definition and its contents. In the DROP command, table space is freed from memory. DROP is a DDL(Data Definition Language) command. In the DROP command,…

SQL Interview Question

DotNetTechnologiesTutorials

What is difference between Delete and truncate? Truncate : Truncate remove all the records from table at one go. It is DDL statement because it delete the auto increment or identity sequence from table It can not use where condition. It is faster than delete…

SQL Tutorials

DotNetTechnologiesTutorials

What are some common clauses or filter used with Select Query in SQL ? Below are some frequent SQL clauses/filter used in conjunction with a SELECT query: WHERE clause - In SQL, the WHERE clause is used to filter records that are required depending on certai…

Common Clause or Filter in SQL

DotNetTechnologiesTutorials

What is the difference between SQL and Oracle?   SQL :  SQL Server Support only Windows and Linux operating systems. there is packages are not taken place in SQL server  While It is less Powerful than Oracle Sql is developed by Microsoft It uses auto increme…

Difference of SQL and Oracle

DotNetTechnologiesTutorials