How can you append an identity column to a temporary table?


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

Post New Answer

More SQL Server Interview Questions

Do you know what are the properties of the relational tables?

0 Answers  


What is lock escalation?

1 Answers  


How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

9 Answers   TCS,


What do mean by xml datatype?

0 Answers  


How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

4 Answers   IBM,






Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

0 Answers  


Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  


What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,


What will happen if a column containing char type data is changed to the nchar data type?

0 Answers  


How to generate create table script on an existing table in ms sql server?

0 Answers  


What is sql server database?

0 Answers  


What are various ways to enhance the ssrs report?

0 Answers  


Categories