Answer Posted / krish

select max(sal) frem tbl where sal <(select max(sal) from tbl;

What is the difference between createstatement and preparedstatement?

921

---

What are orphan records?

917

---

How many types of database relationship in sql server?

1033

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

932

---

Tell me what is normalization? Explain different forms of normalization?

1018

---

What are the events recorded in a transaction log?

981

---

What are the advantages of passing name-value pairs as parameters?

1151

---

What is built-in function?

978

---

How to declare a cursor with "declare ... Cursor" in ms sql server?

1021

---

How to create an index on an existing table in ms sql server?

959

---

Explain multiserver query

1006

---

How to test odbc dsn connection settings?

1002

---

Where to find ntwdblib.dll version 2000.80.194.0?

946

---

what are different types of backups available in sql server? : Sql server database administration

918

---

Do you know exporting and importing utility?

1022

---