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 difference between push and pull subscription? : sql server replication
What is sql server replication? : sql server replication
What is clr ddl trigger?
my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
How the authentication mode can be changed?
Explain collation?
WHAT IS UNIQUE IDENTIFIER DATA TYPE?
Which are new data types introduced in sql server 2008?
What does executeupdate return?
What is the architecture of ms sql reporting service?
What is difference between commit and rollback when used in transactions?