Table Variables
What is Table Variables Table variables like variable, its creating as variable like DECLARE statement. Table variable table’s schema create in tempdb database and data store in Memory and its name start with hash...
Tagged: temp table sql server
Local temp table and Global temp table
What is Local temp table and Global temp table Temp tables are like a physical table but it’s always creating in tempdb database and its name start with hash (#), It’s automatically drop when...
Recent Comments