Answer Posted / ivee

Suppose we are having a table called abc which has field
name as marks, subject and roll
now roll2 and roll3 has the same minimum marks as 40
so the query will be

select roll from abc where marks=(select min(marks) from
abc)

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

944

---

Difference between Sql server reporting services and Crystal reports?

172

---

Explain sql server authentication modes?

1138

---

What is update locks?

895

---

How do I delete a sql server database?

1048

---

How to find which stored procedure is currently running in sql server?

997

---

How to execute a sql statement using mssql_query()?

1056

---

What is database mirroring?

1123

---

What are distributed partitioned views?

1083

---

How to rebuild all indexes on a single table?

1063

---

What is key set driven?

963

---

What is etl - extraction, transformation, and loading?

920

---

what is create database syntax? : Sql server database administration

1113

---

What are the functions in sql server?

955

---

How can I track the changes or identify the latest insert-update-delete from a table?

971

---