What is the difference between a check constraint and a rule?

0 Answers  

---

What are number line correlation administrators will use while working with a subquery?

0 Answers  

---

What do you mean by an execution plan? How would you view it?

0 Answers  

---

explain different types of cursors? : Sql server database administration

0 Answers  

---

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

---

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

0 Answers  

---

what is unique and xaml nonclustered index

0 Answers  

---

What is single-user mode?

0 Answers  

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

Write an sql query to find first weekday of the month?

0 Answers  

---

What is sql profiler. What are the default templates with it? : sql server database administration

0 Answers  

---

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

0 Answers   Global Logic,

---