What are the differences between local and global temporary tables?


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

Post New Answer

More SQL Server Interview Questions

What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?

4 Answers   Wipro,


what is create database syntax? : Sql server database administration

0 Answers  


How dts is used to extract, transform and consolidate data?

0 Answers  


Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

2 Answers  


What are the default system databases in sql server 2000?

0 Answers  






What is referential integrity and how is it achieved?

1 Answers   Adea Solutions,


How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,


What is sub-query in sql server? Explain its properties.

0 Answers  


How to insert new line characters into strings?

0 Answers  


What are the four main query statements?

7 Answers   Wipro,


How each E-R model constructs can be mapped to the relational model?

0 Answers   HCL,


What is default port number for sql server 2000?

0 Answers  


Categories