Can we call SP inside a query?

5 Answers   CA, CarrizalSoft Technologies, Wipro,

---

Distinguish between commit and rollback?

0 Answers  

---

Can you use order by when defining a view?

0 Answers  

---

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

---

What is the stuff and how does it differ from the replace function?

0 Answers  

---

What are the benefits of filtered indexes?

0 Answers  

---

What are the types of containers in ssis?

0 Answers  

---

please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 Answers  

---

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

1 Answers   Aviva,

---

What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

9 Answers  

---

How to create logins using windows Authentication mode?

2 Answers  

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,

---