Yesterday, we had covered the basics of temporary tables in Oracle. Today, we will cover the basic features of temp tables in MS SQL Server. Unlike Oracle, MS SQL Server has local and global temporary tables. Usage of temporary tables in MS SQL Server is more developer friendly and they are widely used in development. Local temporary tables are visible only in current session while global temporary tables are visible across all sessions.