Loading

create temporary and then select query

Devendra Kumar

i have multiple table i want insert all table details in temporary table and then select query in this temporary table

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bikesh Srivastava9y ago
yes see below
create table #tabl_name (id int,name varchar(10)) something like this query.
Amit Gupta9y ago
You can use DataTable.Copy () function. Like
var newDataTable = oldDataTable.Copy ();
// do your stuff with newDataTable