Answer Posted / kaviraj.y

SELECT * from emp_table WHERE e_id>=5 AND e_id<=7;

How to connect Azure federated root database and apply federation in entity framework?

107

---

List out different types of normalizations in sql server and explain each of them?

882

---

How to how to convert numeric expression data types using the convert() function??

987

---

Where can you find the error log information? : sql server database administration

970

---

How do you trace the traffic hitting a sql server?

1067

---

What is linked report?

118

---

What do you understand by the data quality services in sql server?

899

---

What are the different authentication modes in sql server? How can it be changed?

1021

---

What are various ways to enhance the ssrs report?

920

---

How to create an multi-statement table-valued function?

936

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

855

---

How can you find out which stored procedures are recompiling?

878

---

What are xml indexes?

886

---

Does index speed up select statements?

973

---

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

933

---