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
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What happens if you delete a table that is used by a view?
What is difference between commit and rollback when used in transactions?
Explain what is the purpose of sql profiler in sql server?
How to create a new table in a given schema?
What are the differences between left join and inner join in sql server?
How to create a local temporary stored procedure?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
How to see the event list of an existing trigger using sys.trigger_events?
What is the need for group functions in sql?
Different types of keys in SQL?
what are the types of indexes? : Sql server database administration
Mention the different types of triggers?
what is the difference between Delete and Truncate command in SQL
What are the types of subscriptions in SQL Server replication?