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

Do you know what is bit data type and whats the information that can be stored inside a bit column?

547


What happens if you delete a table that is used by a view?

557


What is difference between commit and rollback when used in transactions?

491


Explain what is the purpose of sql profiler in sql server?

546


How to create a new table in a given schema?

652






What are the differences between left join and inner join in sql server?

578


How to create a local temporary stored procedure?

495


What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

544


How to see the event list of an existing trigger using sys.trigger_events?

567


What is the need for group functions in sql?

557


Different types of keys in SQL?

620


what are the types of indexes? : Sql server database administration

591


Mention the different types of triggers?

541


what is the difference between Delete and Truncate command in SQL

622


What are the types of subscriptions in SQL Server replication?

544