What is difference between global temporary tables and local temporary tables?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What happens if ntwdblib.dll is missing on your machine?

0 Answers  


When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

0 Answers  


as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

0 Answers  


What is a view in sql?

0 Answers  


What do you understand by replication in sql server?

0 Answers  






Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  


Do you know clustered and non-clustered index?

0 Answers  


What is the difference between a stored procedure and a user defined function in sql server?

2 Answers   Millennium,


What happens if you insert a duplicate key for the primary key column in ms sql server?

0 Answers  


Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

0 Answers  


Write a program to fetch first 10 records from a file?

0 Answers   Amdocs,


do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  


Categories