What are the different types of stored procedures?

0 Answers  

---

two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?

5 Answers   CSE,

---

How to implement service broker?

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  

---

How to return the top 5 rows from a select query in ms sql server?

0 Answers  

---

---

What is a View ? Can we insert, Update and delete a view?

0 Answers   Arigo Infotech,

---

What is always encrypted?

0 Answers  

---

What is b tree index?

0 Answers  

---

Write down the syntax and an example for create, rename and delete index?

0 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

What is difference between views and tables?

0 Answers  

---

What is tablesample?

0 Answers  

---