Answer Posted / rajasekar

er
# 9
select top 1 * from (
SELECT DISTINCT TOP 3 salary
FROM tblemp
ORDER BY salary desc) t order by salary asc

Is it ok to shrink transaction log?

939

---

Explain transaction server distributed transaction?

922

---

What are the types of processing and explain each? : sql server analysis services, ssas

1110

---

How can sql server instances be hidden?

896

---

Why I have to use stored procedures?

981

---

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

917

---

what's the information that can be stored inside a bit column? : Sql server database administration

968

---

What happens if time-only values are provided as date and time literals?

954

---

How is sql server used?

910

---

What is the difference between ddl and dml?

1005

---

Can you index views?

853

---

What are the properties of the transactions?

1055

---

What are the disadvantages of using querystrings to send data from one page to another?

933

---

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

1049

---

What is format parameter in ssrs?

136

---