How to achieve Paging of records in SQL SERVER?

0 Answers   Petranics Solutions,

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

how would you troubleshoot blocking? : Sql server database administration

0 Answers  

---

What is difference between stored procedure and user defined function?

0 Answers  

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

0 Answers  

---

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

0 Answers  

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

0 Answers   IGT,

---

How do you start single user mode in clustered installations?

0 Answers  

---

Can an automatic recovery be initiated by a user?

0 Answers  

---

two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 Answers  

---

Relational calculus is what type of language?

0 Answers   HCL,

---

What are the joins in sql server? : sql server database administration

0 Answers  

---