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 |
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2008-04-14 : 11:56:59
|
From ASP.NET, how to make temporary table in SQL server from select statement which build in a button?For example, if the user clicks a button a table will create based on statement below: “Select * from Order where [order by] = ‘Mike Lee’” |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-14 : 12:01:29
|
SELECT fields INTO TableName FROM SourceTable WHERE condition.But i dont think this should be done from your app on clicking a button as it creates table each time so that second time you do this it will error stating that object is already present. This is used only for one time execution unless you change table name each time. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-04-15 : 03:03:39
|
quote: Originally posted by Sun Foster From ASP.NET, how to make temporary table in SQL server from select statement which build in a button?For example, if the user clicks a button a table will create based on statement below: “Select * from Order where [order by] = ‘Mike Lee’”
Why do you want to do this?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|