Temporary table in SQL
1 .What is temporary table in SQL and What is difference between Temp table and view ? A temporary table is a base table that is not stored in the database, but instead exists only while the database session in which it was created is active. It would automatically deleted when the last connection to the query window that created the table is terminated. We can use Temporary Tables to store and process intermediate results . View Temporary table A view exists only for a single query. Each time you use the name of a view, its table is recreated from existing data. A temporary table exists for the entire database session in which it was created A view is automatically populated with the data retrieved by the query that defines it You must add data to a temporary table with SQL INSERT commands Only views that meet the...