Answer Posted / purabi roy(sarkar)

select top 3* from Tablename
where columnname in ( select top 7columnname from table
name order by columnname desc )
and columnname not in( select top 4columnname from
tablename order by columnname desc )
order by columnname desc

Can you edit the .rdl code associated with a linked report?

164

---

Explain stored procedure?

1060

---

What are the advantages of mirroring?

995

---

You want to implement the one-to-one relationship while designing tables. How would you do it?

969

---

What is the difference between join and inner join?

1021

---

How to convert a numeric expression from one data type to another?

1023

---

What is difference between Datepart() and Datename() in SqlServer?

1212

---

What is sql server profiler?

1017

---

can a table be moved to different filegroup? : Sql server administration

984

---

What are the differences between clustered and non-clustered index?

1033

---

What is outer join in sql server joins?

1126

---

Can you always create a cache of a report?

174

---

What are the recovery models for a database?

1108

---

Can you please explain the difference between primary keys and foreign keys?

1117

---

How to declare and use cursor variables?

1176

---