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?
Answers were Sorted based on User's Feedback
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 |
Answer / 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 |
What is compound operators?
What is the maximum row of a size?
What is the difference between views and stored procedures? Can we have input parameters for views?
What is a transact-sql statement?
How to create an multi-statement table-valued function?
To find second largest salary in Employee table
can any one please send sql quries most used in applications.
What is #table in sql server?
How do I find sql server instance name?
What is thr feature of change data capture?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
What happens if date-only values are provided as date and time literals?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)