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 |
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
what are different types of backups available in sql server? : Sql server database administration
What is key attribute?
What is difference between line feed ( ) and carriage return ( )?
What is the difference between char, varchar and nvarchar?
What are the difference between data length and length in SQL Server-2008?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What is tcl in sql server?
What do you understand by SQL*Net?
What are locks in sql?
What is database replication?
How to get number of days in a given year?
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)