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

Question

Akkiraju Ivaturi · Answer

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 Rawat · Answer

Good evening... Here is your query : insert top(10) into test EmployeeDetailsMaster ( EmpIdEmployeeName ) select EmpIdEmployeeName from EmployeeDetailsMaster I have tested this and is working.

naga jyothi · Answer

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 EmpIdEmployeeName from EmployeeDetailsMaster) Error comes sg 156 Level 15 State 1 Line 1 Incorrect syntax near the keyword 'from'. Mukesh please rectify the error

Mukesh Rawat · Answer

Insert into yourtablename from select top 10 * from youranothertablename. Note :yourtablename & youranothertablename should be same else specify the column names.