Our Training Programs

All contents are copyright of their authors.

How to wite a query to insert only 10 records into the database in sql server

How to wite a query to insert only 10 records into the database in sql server

naga jyothi

14yAsked Aug 10, 2012, 2:06 AM3.2k

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Akkiraju Ivaturi14y ago
There are two different techniques to limit the insertion of rows into the table.

Method 1:

INSERT INTO TABLE …
SELECT TOP (N) Cols…
FROM Table1

Method 2:

INSERT TOP(N) INTO TABLE …
SELECT Cols…
FROM Table1

-- Option 1: Top with Select
INSERT INTO InsertTestValue (ID)
SELECT TOP (2) ID
FROM TestValue

GO
-- Option 2: Top with Insert
INSERT TOP (2) INTO InsertTestValue1 (ID)
SELECT ID
FROM TestValue

GO
Mukesh Rawat14y ago
Good evening...

Here is your query :

insert top(10) into testEmployeeDetailsMaster (EmpId,EmployeeName)
select EmpId,EmployeeName from EmployeeDetailsMaster

I have tested this and is working.
naga jyothi14y ago
Hai Mukesh Rawat good morning i try this query in sql server the error occurs like this

sg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'from'.

Query "insert into EmployeeDetailsMaster from (select top 10 EmpId,EmployeeName from EmployeeDetailsMaster)

Error comes sg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'from'.

Mukesh please rectify the error
Mukesh Rawat14y ago
Insert into yourtablename from select top 10 * from youranothertablename. Note :yourtablename & youranothertablename should be same else specify the column names.