Answer Posted / karthik

select * from (select rownum r , emp.* from emp)
where
r='&n'

Give the value of n. It will return the nth record.

Difference between report and query parameter.

1144

---

Explain error and transaction handling in sql server?

1063

---

Tell me what is the stuff and how does it differ from the replace function?

1035

---

What is measure group, measure? : sql server analysis services, ssas

1072

---

What are entities and relationships?

1024

---

In which sql server version report builder introduced?

152

---

How to insert new line characters into strings?

1034

---

Can binary strings be converted into numeric or float data types?

1099

---

Define cursor locking

1061

---

What is a database in ms sql server?

1107

---

Can sql servers linked to other servers like oracle?

1009

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

1008

---

What is table constraint?

1052

---

What is difference between rollback immediate and with no_wait during alter database?

1134

---

What are trace files?

1004

---