Define Local temporary table and global temporary table

Define Local temporary table and global temporary table.

- Local temporary table is created by prefixing name with pound sign like (#table_name).
- Global temporary table is created by prefixing name with Double pound sign like (##table_name).
- Local temporary table is dropped when the stored procedure completes.
- Global temporary tables are dropped when session that created the table ends
When do we use the UPDATE_STATISTICS command?
UPDATE_STATISTICS updates the indexes on the tables when there is large processing of data........
Difference between clustered and non-clustered index
Both stored as B-tree structure. The leaf level of a clustered index is the actual data where as leaf level of a non-clustered index is pointer to data.......
Inline variable assignment in sql server 2008 - Sql server 2008
Inline variable assignment in SQL Server 2008 enables to – declare, and assign the variables in a ‘single line’..........
Post your comment

Related Content

Follow us

▲