Answer Posted / sagun sawant

;with TEST as (select Row_Number() over (partition by sname
order by sname) as ROWNO,sname from student)
select sname from TEST order by ROWNO,(case when sname
= 'RAM' then 1
when sname = 'RAJ' then 2 end)

How do you implement session management in SQL Server mode?

569

---

What are database states in ms sql server?

660

---

What is mscorsvw.exe - process - microsoft .net framework ngen?

537

---

What stored by the master? : sql server database administration

589

---

What is the sql case statement used for?

571

---

---

What is the difference between upgrade and migration in sql server?

600

---

How to transfer an existing table from one schema to another schema in ms sql server?

519

---

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

2128

---

Explain the properties of subqueries in sql server?

552

---

What is a field in a table?

586

---

How to delete duplicate rows in sql server?

585

---

Define right outer join?

556

---

How to write a query with a left outer join in ms sql server?

585

---

What are the differences between having and where clause.

566

---

what is a schema in sql server 2005? : Sql server database administration

523

---