Answer Posted / skumar

There are many features introduced.
1. XML data type
2. Synonym
3. Instead of Trigger on indexed views
4. CROSS APPLY
5. INTERSECT and EXCEPT statements
6. CTE (Common Table Expressions)
7. PIVOT and UNPIVOT
8. TRY...CATCH and RAISERROR
9. .NET CLR integration
10. Custom data types
11. New data types like NTEXT,NVARCHAR,NCHAR
12.64 bit platform
13.DDL Triggers
14. New functions like RANK(),DENSE_RANK() and ROW_NUMBER
15. MAX Keyword
16. Table variable

Why functions are used in sql server?

1017

---

How to create a view with data from multiple tables?

1064

---

How to create dbo table in sql server?

1005

---

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

2053

---

In what version of sql server were synonyms released?

1000

---

What is correlated subquery in sql server?

1127

---

Can we write ddl in trigger?

970

---

Explain boyce and codd normal form(bcnf)?

1015

---

What are the disadvantages of primary key and foreign key in SQL?

1151

---

Are null values the same as that of zero or a blank space?

1088

---

What is transaction server explicit transaction?

1089

---

Tell me the phases a transaction has to undergo?

1019

---

What have included columns when we talk about sql server indexing?

1078

---

What is difference between table aliases and column aliases? Do they affect performance?

1021

---

How can you check the level of fragmentation on a table?

1087

---