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

Can a unique index be created on a column, which contains null?

919

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

960

---

How to declare and use cursor variables?

1171

---

What is the difference between inner join and equi join?

997

---

What is meant by indexing?

1022

---

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1108

---

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

2093

---

What do you understand by check constraint in sql server?

945

---

How to insert stored procedure result into temporary table?

1015

---

Are all views updatable ?

1152

---

What are the characteristics of modern DBMS?

1092

---

Can we shrink data file in sql server?

1049

---

What does ss stand for sexually?

1084

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1137

---

Explain log shipping and mention its advantages.

1044

---