1. What is CUBE Operator?
2. what are the new data types are available in sql server 2008?
3. Inisde a nested queries, how many subqueries u can have?

Answer Posted / anand

2.New date and time data types
3.32 sub queries you can have in nested queries

Is This Answer Correct ?    4 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which tools are available to manage SQL Azure databases and servers?

107


How to round a numeric value to a specific precision?

768


How do I find the default sql server instance?

695


What are the steps to follow to configure SQL*Net?

774


What is a scheduled job or what is a scheduled task?

711






Do you know what are the differences between lost updates and uncommitted dependencies?

737


What is table level trigger?

760


what are constraints? Explain different types of constraints? : Sql server database administration

661


What is the difference between count () and rowcount ()?

706


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

669


How to convert a unicode strings to non-unicode strings?

742


Mention the differences between sql server and mysql.

681


What happens if you are trying to access a schema not owned by you?

720


What is logshipping and its purpose?

742


How to display a past time in days, hours and minutes?

741