Posts Tagged ‘insert’

Inserting Data Into Table Using Select Query

September 1, 2009 Leave a comment

In SQL, sometimes we need to select some data from one table and insert data into another table, this can be done as follows with a simple sql query:

Insert into Table1 (c1, c2, c3, c4, c5)
(Select c1, c2, c3, c4, c5 from Table2)

But make sure that both the tables have same fields, data type..


CRUD(Create/Insert/Update/Delete) with MVC Framework, ADO.Net Entity Data Model

This article will explain you how to  create, read, insert, update, delete operations with mvc with entity model.

Very nice article who are beginners with mvc framework.