A small application of Insert -- copying data

The deeper the study, the more profound the knowledge.

The Insert method in SQL is insert into Table value (). When using the SQL Insert statement today.

Implement a function to copy a piece of data. The primary key is different and the data is the same.

Example:

1. Table Structure

The environment is SQL Server2008.

2. Code

(1) Replace the Value statement with the select statement,

(2) In the select statement, replace the primary key with the primary key of the insert statement.

Insert into Student (No, Name, Sex, Age)
Select 2, Name, Sex, Age
From Student
Where No = 1

3. Description

At first, you must have a data record and then copy it.

It is very easy to use and useful at critical moments.

I hope this small example will help you understand SQL.