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
Post your comments / questions
Recent Article
- Fix-Gradient effect turning to gray in after effects
- How to blur an image in python?
- ModuleNotFoundError: No module named 'whois' in Python GoviralHost Without Terminal
- How to Convert Image to Pencil Sketch in Python?
- AttributeError: module 'urllib' has no attribute 'request' - Python
- How to Extract audio from video files using python?
- PermissionError: [Errno 13] Permission denied: 'shampoo_sales.csv' - Python
- [WinError 145] The directory is not empty: 'FolderPath' - Python
Related Article