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’”
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.
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’”
Create a table in SQL server
Posted - 04/14/2008 : 11:56:59
