How to Insert Data into a Table in SQL

In this article I am going to explain about how to insert data in table.
  • 2124

Introduction

In this article I am going to explain about how to insert data in table. INSERT TABLE statement is used to insert data in table. This statement is part of DML (Data Manipulation Language ). It means this statement is used to manipulate the database.

Example

Fallowing Statement create a invoices table in DATABASE

Clipboard10.jpg

Fallowing Statement insert data in mcninvoices table

Clipboard32.jpg

An other way to insert data in mcnemp table

Clipboard14.jpg

© 2018 DotNetHeaven. All rights reserved.