Answer Posted / vijay

The SQL join command is used to join two or more tables. At
times you may need to join two or more tables to retrieve
the information you need from your SQL database

Types Of Joins-
1.Inner Join
2.Outer Join -types -
left Outer,
Right Outer,
Full Join

3.Cross Join
4.Self Join

Which table keeps information about stored procedures?

939

---

How to find which stored procedure is currently running in sql server?

996

---

What is a non clustered primary key?

926

---

What number sorts of privileges are accessible in sql?

1037

---

What is difference statement and preparedstatement?

981

---

What is command parameter in ssrs?

161

---

Explain the cursor lock types?

1058

---

What is dbcc updateusage?

1204

---

List all the types of user-defined functions?

1102

---

What is the use of sign function?

1125

---

How do I view a trc file?

943

---

What is the difference between ddl and dml?

1048

---

Can I disable or restrict ssrs export formats (rendering formats)?

150

---

When I run the sql server 2000 setup, it just hangs. What do I do?

1083

---

what are the new features introduced in sql server 2000? : Sql server database administration

921

---