SQL Insert Query Without Index

This post have all the query and synatx which a biggner and experianced SQL users need to know and use in their daily working Life for inserting the data without index.

Insert Into:

1- insert query when index column is exists in Table

Insert into 'table_name' (Column_1,Column_2,......,Column_n) Values (Values_1,Val_2,.....,Val_n);

Initial Table - Table Name- User_Detail

   

    

Insert into User_Detail 
(User_name,User_Mobile,User_email_id,Pin_code)
Values('Programming    Logic World',1234512345,'programminglogicworld@gmail.com',123456);

How to join two tables in sql server?

Create table Dizsweb_A(Dizsweb_A_ID, Name, Mobile_NO, Email_ID)
Create table Dizsweb_B(Dizsweb_B_ID, Name, Mobile_NO, Email_ID)

Now we can join the two tables on the basis of wither mobile no or email id as Both are unique set of data.

Select * from Dizsweb_A  A Left outer join Dizsweb_B B on B.mobile_no=A.Mobile_no
OR
Select * from Dizsweb_A  A Left outer join Dizsweb_B B on B.email_id=A.email_id

Complete SQL Usery and Syntax Details