Get Value(s) from one table and Insert into column of another or same table

Solution INSERT INTO destination_table (column names ) (select column names from the source_table ); e.g. INSERT INTO [dbo].[t_Menu] (Name,ParentId)VALUES ('CustomizedReports',(select id from t_Menu where Name='Reports')) go Explanation Here I have inserted the value in the same table, you can write name of the other table in select statement if you want to get from other... Continue Reading →

Create a free website or blog at WordPress.com.

Up ↑

Create your website at WordPress.com
Get started