SQL INSERT QUERY

This Command use for Insert New Record in to Table .

INSERT INTO Syntax.

INSERT INTO  <Table name> (Table Column names) values (Parameters);

'Insert' statement example use  in Four way.

SQL Query Tasting  with  MSSQL Server Management Studio.

1).Insert with Custom Columns 

             Insert into Stud_Details(stud_ID,stud_Name)values(2,'Jone');

                                                                                                                                                                      

2)Inset with All Columns .

            Insert Into Stud_Details(Stud_Id,Stud_Name,Stud_adr,_stud_Dob)values(4,'JoneDear','Street-             B','2023-03-18');

3)Insert statement without Column names.

                Insert Into Stud_details values(5,'JoneMax','Street-X','2023-03-18');

4)Insert Query  with select Query .

            Insert into Stud_Details Select 6,Stud_Name,Stud_adr,_stud_Dob From Stud_Details where  Stud_Id=2;

         Thank You....

SELECT Query - MSSQL Server

Sequence Of  SELECT Statement.

[SELECT ] [Column name] [FROM  [Table Name] 

SELECT Query with One Column. 

SELECT Query with multi  Columns.

*Columns Separate with ' , ' Symbol

     

Example :

                SELEC  Stud_Id , Stud_Name FROM Stud_Details

 

SELECT Query with all Columns With ' * ' Mark

 * No Need To Write All Column Names.

   

    Example :

                  SELECT  * FROM  Stud_Details;

* If  you have question with this  please comment , I will reply to you , Thank you..

INSERT Record Without Query - MSSQL Server

Go to Microsoft  SQL Server Management Studio 

• Right Click On Table(Stud_Details)

• Click on edit top row 200

• Enter record which related to column names

*'Stud_id' Column Field is Primary Key Hence It is Compulsory to add value.

Create Table Using MSSQL SERVER

• Click On Database Folder and Expand.
• Right Click on Tables Folder.

• Move 'New' and Click on Table

• Display Table Design View
• Enter Column Names and Select Data Type which you need.

• Right Click on Column which you wish to selected as  Primary Key and Click on 'Primary Key'.

• Click On 'Save' Button.

• Give the name which you need for Table and Click 'Ok'

Now you Can See table in table Folder which you created.

Create Database using MSSQL SERVER

 Login to  Server

Right Click On Database Folder Like Below image

Enter database name

Click on Ok Button

Now Completed your database Creating part.

What is SQL

 

What is SQL

A standardized programming language called Structured Query Language (SQL) is used to administer relational databases and carry out various operations on the data they contain. SQL is frequently used by database administrators as well as programmers creating scripts for data integration and data analysts setting up and running analytical queries.

According to ANSI (American National Standards Institute). To change data on a database or get data from one, SQL statements are employed. Oracle, Sybase, Microsoft SQL Server, Access, Ingres, and other popular relational database management systems are a few examples of systems that employ SQL.

Despite using SQL often, most database systems also contain proprietary extensions that are typically only utilized with that systems. The typical SQL commands, however, such as "Select," "Insert," "Update," "Delete," "Create," and "Drop," can be used to complete nearly any database-related tasks.

You have a grate opportunity to learn SQL with Us.