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 the maximum number of index per table?
I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?
Explain the difference between function and stored procedure?
What is difference between rownum and rowid?
What are differences in between sql server 2012 and sql server 2016?
How we Resize table,temp table, database and log file size in SQL Server 2005
What are the advantages of using stored procedures in sql server?
What is a trigger what are the advantages of trigger?
After removing a table from database, what other related objects have to be dropped explicitly?
what is datawarehouse?
What is sql server profiler?
What is a trigger and its types?