What is difference between temp table and cte?


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

Post New Answer

More SQL Server Interview Questions

What are orphan records?

0 Answers  


what is Buffer cash and Log Cache? Can you Explain it?

1 Answers   Wipro,


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers   HCL, Wipro,


What is data compression? : sql server database administration

0 Answers  


Write a sql query to display the current date?

0 Answers  






Give an example of why you would want to denormalize a database

0 Answers  


How to round a numeric value to a specific precision?

0 Answers  


What is the difference between a Application Server and a Database

3 Answers   Oracle,


What is the difference between count and distinct count?

0 Answers  


What are sql servers used for?

0 Answers  


What is xml datatype?

0 Answers  


Explain how to send email from sql database?

0 Answers  


Categories