Answer Posted / mpg

There are 5 types of join in sql server 2005

inner join
outer join
cross join
equi join
self join

How to handle error or exception in sql?

980

---

1 01 101 01010

2045

---

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

1053

---

Write an SQL query to obtain the 2nd highest salary.

1067

---

how can you check the level of fragmentation on a table? : Sql server administration

967

---

Explain trigger classes i.e. Instead of and after trigger?

875

---

What are the differences between substr and charindex in sql server.

1107

---

Do you know what is similarity and difference between truncate and delete in sql?

1003

---

Explain how would you store your query in an SSRS report or a Database server?

128

---

What do you understand by physical_only option in dbcc checkdb?

977

---

Is sql server free?

913

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

905

---

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

1148

---

What is the difference between a stored procedure and a user defined function?

1016

---

How many categories of data types used by sql server?

1010

---