Answer Posted / ashish sehra

Cursor is the current position of recordset.There are 4
types of cursors.
1.forward Only (Default)
2.Static
3.Keyset
4.Dynamic

Explain how to send email from sql database?

1054

---

Explain about SQL server 2005?

983

---

What are built in functions?

1027

---

Define clusters?

1089

---

what are cursors? : Sql server database administration

1067

---

What is the difference between upgrade and migration in sql server?

1100

---

How to copy data from one table to another table?

1000

---

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

969

---

Scalability, Availability, Integration with internet, etc.)?

2885

---

What does ss stand for sexually?

1092

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2934

---

Can you index views?

900

---

Do you know what is openxml in sql server?

1074

---

How to create database with physical files specified in ms sql server?

1004

---

 Explain what is sql override for a source taLle in a mapping?

1016

---