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 / sachin kalia

Can any one tell me the exact number,This question is aksed number of times in different org
" how many subqueries u can have".

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

709


What is a constant or literal in ms sql server?

785


How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

741


What is the purpose of the tempdb database?

753


How to drop an existing stored procedure in ms sql server?

725






How many non clustered indexes there can be on table ?

674


Mention the different types of replication in sql server.

746


How to add code to the existing article (using improve article)?

791


What is truncate table?

709


What is change data capture (cdc) in sql server 2008?

755


How do I delete a sql server database?

724


A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

716


explain extended properties

714


How you would rewrite the sql query to return the customerid sorted numerically?

758


Explain the architecture of ms sql reporting service?

694