Answer Posted / sql developer

Hi,

Here is the difference between SQL Server 2005 and SQL
Server 2008.

Its contains difference between various versions of SQL
Server:

http://learnsqltips.blogspot.in/2012/01/introduction-to-sql-
server.html

How to create function with parameter in sql server?

1094

---

How to create a new login name in ms sql server?

1049

---

what is a schema in sql server 2005? : Sql server database administration

1012

---

What does the on update no action do?

1011

---

What is database dimension? : sql server analysis services, ssas

1068

---

What is a partitioned view?

978

---

What is de-normalization in sql database administration? Give examples?

968

---

How can we check the sql server version?

1050

---

how you can deploy an ssrs report?

178

---

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

1012

---

What are secondary xml indexes?

1016

---

Can an automatic recovery be initiated by a user?

985

---

What is the tcp/ip port on which sql server runs?

1139

---

Which rendering formats are affected by the pagesize properties?

144

---

What are the differences between decimal and float in ms sql server?

1219

---