Answer Posted / sandeep

magic table two part
1)Inserted
a)Insert
b)update
2)Deleted

What are filegroups in sql server?

1058

---

What is difference between index and primary key?

1100

---

what kind of lan types do you know? : Sql server database administration

980

---

please differentiate between delete and truncate?

993

---

Do you know what is user defined datatypes and when you should go for them?

966

---

How many levels of sp nesting is possible?

1054

---

What function does a database engine serve in the sql server?

1034

---

Can we use where clause with group by?

899

---

How to retrieve field values using mssql_result()?

1313

---

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

979

---

What are the advantages of having an index on the sql server?

925

---

What is meant by indexing?

1022

---

how to avoid cursors? : Sql server database administration

969

---

What is command parameter in ssrs?

161

---

What is query processing?

935

---