c# .net Adsense ADO.NET Linq Viruses/security asp.net MVC JQuery Angular-js Node-js SEO Java C++ SQL API Networking vb.net .Net Css JavaScript Generics c#.Net entity framework HTML Website host Website Construction Guide HTTP tutorial W3C tutorial Web Services JSON Psychology Ionic framework Angular ReactJS Python Computer Android
SQL

How to modify or insert already existing table value using by another table in sql server?

| | SQL

In this article, I describe How to modify or insert into already existing table value using by another table.This is achieved by a select statement. As here I am select top 10 rows from dbo.Employee table and insert into dbo.Employee_Test Table.

INSERTINTO DBO.EMPLOYEE_TEST

SELECT TOP 10 * FROM DBO.EMPLOYEE
 

Here, DBO.EMPLOYEE_TEST is already existing table in the database; we inserted top 10 rows value from dbo.Employee table