Answer Posted / mangalesh porwal

HERE N IS THE NO WHICH HIGHEST NO U WANT..........
IT SURELY WORKS.....

SELECT TOP 1 * FROM (SELECT TOP N * FROM (SELECT ROLLNO FROM TABLE_NM ) AS D ORDER BY ROLLNO DESC) AS P ORDER BY ROLLNO

How many types of triggers in sql server?

1094

---

What are the dis_advantages of stored procedures, triggers, indexes?

2275

---

Can we write ddl in trigger?

972

---

Why it is recommended to avoid referencing a floating point column in the where clause?

1017

---

Using the customer, and order table in northwind database, please write a query to produce xml?

1119

---

What command do we use to rename a database?

1119

---

What is data source document?

1089

---

Is null in sql server?

1043

---

When do you think a developer should use sql server-based cursors?

1106

---

what are constraints? Explain different types of constraints? : Sql server database administration

1050

---

What is an entity-relationship diagram (erd)?

1313

---

Do you know what is rank function?

1128

---

What are 3 ways to get a count of the number of records in a table?

1122

---

What are .mdf files?

1016

---

What is 2nf normalization?

1090

---