How to select an exiting database using mssql_select_db()?

0 Answers  

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

List the ways in which dynamic sql can be executed?

0 Answers  

---

do views contain data ?

0 Answers   MCN Solutions,

---

what is hash nonclustered index

0 Answers  

---

How can I create a report based on a query? : sql server management studio

0 Answers  

---

How to optimize stored procedure optimization?

0 Answers  

---

What are the steps you can take to avoid “deadlocks”?

0 Answers  

---

What are trace files?

0 Answers  

---

What is sql service broker?

0 Answers  

---

Define msdb database?

0 Answers  

---