Answer Posted / suresh

Hi,

select top 1 * from (SELECT TOP 2 * from emp) A Order by
empno desc

What is a trace frag?

646

---

What are the types of stored procedures in an sql server?

478

---

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

597

---

How to convert character strings into numeric values?

579

---

How you can move data or databases between servers and databases in sql server?

570

---

---

What is snapshot report?

129

---

Does view occupy space?

520

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

553

---

What are the components of dbms?

534

---

Is foreign key a primary key?

513

---

What are the parts of a function?

523

---

What is save transaction and save point?

628

---

What is @@error in sql?

625

---

What is sleeping status in sql server?

526

---

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

1758

---