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?
Answer Posted / 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 |
Post New Answer View All Answers
Is port 1433 secure?
what is database replicaion? : Sql server database administration
What is the optimization being performed in oracle and SQL Server?
Can we check locks in database? If so, how can we do this lock check?
What is the native system stored procedure to execute a command against all databases?
How to list all objects in a given schema?
How to convert a table data in XML format in sql server?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What are unicode character string data types in ms sql server?
query processing
What are the restraints imposed on the table design by a merge replication?
What is a periodical index?
What is primary key, unique key, and foreign key?
Define inner join in sql server joins?