Answer Posted / rupinder kaur

there are five types:
inner join
outer join: left outer join,right outer join, full outer
join
equi join
cross join self join

What is the sql case statement used for?

1053

---

Explain about system database?

1020

---

can you instantiate a com object by using t-sql? : Sql server database administration

975

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1024

---

How do you delete a data source?

965

---

Can you explain full-text query in sql server?

982

---

Where in ms sql server is ’100’ equal to ‘0’?

1043

---

What is sql server locking?

962

---

Can a table be moved to different filegroup?

938

---

How to delete database objects with "drop" statements in ms sql server?

1054

---

How we can refresh the view?

1077

---

What are the types of user defined functions in sql server?

1007

---

explain what is raid and what are different types of raid configurations? : Sql server database administration

972

---

How do I trace a query in sql server?

916

---

What is transact-sql ddl trigger?

1066

---