Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
huma
Starting Member
1 Post |
 Posted - 2010-04-06 : 07:35:11
|
| ello evry bdy dre....^_^I have a question.. i want to create a temp table "B" on run time in my C# application.... and on button click event i want that from my already exist table "A" (like table "A" have some columns like 1,2 ,3,4,5,6 ...) some of column data (1,3,6) insert into Table "B"....then i display only table "B" data wht ever way i want... and when i finish ma work then table B will b deleted...( as it is temporary) ....how this will be done in C# and sql...plz help me outHuma Satti |
|
|
sathiesh2005
Yak Posting Veteran
85 Posts |
Posted - 2010-04-06 : 07:50:44
|
| Hi Huma,This should be handled through SQL only.Example:select col1,col3,col6 into #B from ATry the above example.# denotes that the table B is a temp table.Regards,Sathieshkumar. R |
 |
|
|
|
|
|
want to create temp table...??