Where can you add custom error messages to sql server?

0 Answers  

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

Which databases are part of SQL server default installation? Explain the usage of each?

2 Answers   Accenture,

---

What is the difference between a local and a global variable?

5 Answers  

---

What is a self join in sql server?

0 Answers  

---

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

0 Answers  

---

How to retrieve data from log files in SQL SERVER ?????

1 Answers  

---

how to control the amount of free space in your index pages? : Sql server database administration

0 Answers  

---

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---

What is BCP? When does it used in sql server 2012?

0 Answers   TryTechnicals Pvt Ltd,

---

When you use @@error and try-catch?

0 Answers  

---

Please differentiate between a local and a global temporary table?

0 Answers  

---