Answer Posted / arun kumar

select top 1 e.emp_code,e.emp_name,ed.basic_salary from
employee_master e, employee_salary_detail ed where
e.emp_id=ed.emp_id order by basic_salary desc

Why functions are used in sql server?

964

---

What is a transact-sql statement batch in ms sql server?

1024

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1057

---

Explain time data type in sal server 2008?

929

---

Can we add our custom code in ssis?

990

---

What are the operating modes in which database mirroring runs?

1091

---

What’s the use of custom fields in report?

944

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1150

---

Are all views updatable ?

1154

---

Explain following error properties?

1023

---

What are xml indexes?

954

---

What is Lock table in SQL?

1475

---

Explain what is log shipping?

1139

---

What are the rules to use the rowguidcol property to define a globally unique identifier column?

1021

---

Explain about link server in sql server?

1062

---