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 |
Do you know what guidelines should be followed to help minimize deadlocks?
What are the different authentication modes in sql server? How can it be changed?
what is the sql equivaent of the dataset relation object ?
What are null values in ms sql server?
What is the difference between an index and a unique index?
Write a sql query to delete duplicate records from a table called table1
i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L
How to create prepared statements using odbc_prepare()?
can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?
what are three different authentications to connect linked servers?
What is the best way to move n number of DTS package from one SQLServer to another SQLServer?
How do I list the available tables in a database I'm querying?
Oracle (3253)
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)