Answer Posted / bhanu prakash

SELECT TOP 1 * FROM (SELECT TOP N * FROM EMPSAL ORDER BY ID DESC) A ORDER BY ID

When does a workload on SQL Azure get throttled?

131

---

Why is replication required on the sql server?

1107

---

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1105

---

What are the differences between left join and inner join in sql server?

1157

---

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

319

---

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

1033

---

What is intellisense?

1102

---

Explain the stored procedure?

1098

---

What is the purpose of forms?

1004

---

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1898

---

What is attribute relationships, why we need it? : sql server analysis services, ssas

1032

---

What are the types of lock supported by ?

1094

---

What is a trace frag?

1136

---

Are all views updatable ?

1204

---

What is difference between standardization and normalization?

1160

---