Answer Posted / ravindra

Select top 1 <Col-name> from <table> order by RecordTime
desc

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1139

---

What are examples of triggers?

1088

---

what is the difference between count(*) and count(1) ?

1084

---

Explain different types of collation sensitivity?

982

---

 Explain what is sql override for a source taLle in a mapping?

1012

---

What is a print index?

884

---

Explain collation?

1062

---

What are the advantages of using third-party tools?

996

---

What are the disadvantages of merge replication?

1421

---

What is unpivot?

1011

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1916

---

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

945

---

List out the differences between global and local temp tables in sql server?

1060

---

Can two tables share a primary key?

1020

---

How to list all schemas in a database?

1056

---