Answer Posted / madhuparna

select top 1 * from (select top 2 * from employee)A

what's the maximum size of a row? : Sql server database administration

1013

---

What is wrong with sql server client libarary dll, ntwdblib.dll?

994

---

What is difference between delete & truncate commands?

1023

---

Tell me what do you understand by a view? What does the with check option clause for a view do?

956

---

How global temporary tables are represented and its scope?

905

---

Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

184

---

Can We Use Data-grids For Our Report In Ssrs?

177

---

Write a sql query to sort on different column name according to the parameters passed in the function?

852

---

Do you know what is xpath?

1003

---

What are the difference between primary key and unique key? : sql server database administration

892

---

how many triggers you can have on a table? : Sql server database administration

904

---

What is user-defined multi-statement table-valued function?

996

---

What is the use of commit?

954

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

1971

---

Can primary key be a foreign key?

997

---