Answer Posted / john t

If you knowfor sure that the number of rows is 10 then the
above answers given above a great examples. So what if you
don't know the total number of rows in that table? Can you
use Select count(*) from nameoftable;

What the different types of Replication and why are they used?

1043

---

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

1051

---

can we have a nested transaction? : Sql server database administration

1052

---

How data can be copied from one table to another table?

931

---

What is the difference between count () and rowcount ()?

1000

---

Find columns used in stored procedure?

967

---

Explain syntax for viewing trigger?

903

---

Explain the cursor lock types?

1028

---

How many null values we can have in a unique key field in sql server?

932

---

What is partition, how will you implement it? : sql server analysis services, ssas

1028

---

Can we call future method from queueable?

1029

---

How will you know when statistics on a table are obsolete?

1063

---

How to list all stored procedures in the current database using ms sql server?

1109

---

What are the filtered indexes?

1016

---

Is BCNF better than 2NF & 3NF? Why?

1032

---