what are the new features of sql server 2005?

Answer Posted / ramprasshanth

ROLL UP and CUBE are available in ms sql server 2005

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to disable stored procedure sql server?

957


What is the difference between stored procedure and user defined functions?

620


What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

593


How to delete existing rows in a table?

582


Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

518






How to get all stored procedures in sql server?

504


How to convert numeric expression data types using the cast() function?

542


What do you understand by the denormalisation?

549


Name some of the open source software that you can use in alternative to SSR?

105


How to transfer an existing table from one schema to another schema in ms sql server?

504


What are the recovery models for a database?

611


Why use triggers?

565


Explain database normalization?

644


Why do we use non clustered index?

551


Please explain what is “asynchronous” communication in sql server service broker?

506