Answer Posted / santosh kumar sharma

There are 4 types of cursor.
1) Static: Cursor can move to any record but the changes on
the data can't be seen.
2) Dynamic: Most resource extensive. Cursor can move
anywhere and all the changes on the data can be viewed.
3) forward-only: Cursor moves one step forward. Can't move
backwards.
4) Key setdriven: Only Updated data can be viewed. Deleted
and Inserted data cannot be viewed.

Can we linked SharePoint to a SQL database?

1073

---

What is bit data type?

1081

---

How can you tell if a database object is invalid?

1114

---

How to locate and take substrings with charindex() and substring() functions?

1071

---

How to execute a sql statement using odbc_exec()?

1214

---

What is the difference between getdate and sysdatetime?

1060

---

How to get a list of columns using the "sys.columns" view in ms sql server?

1004

---

What is the difference between drop table and truncate table?

973

---

what is the system function to get the current user's user id? : Sql server database administration

1069

---

What is the difference between Stored Procedures and triggers?

1131

---

Explain system rowset functions?

1043

---

What is ems sql management studio? : sql server management studio

1163

---

What is read committed?

1169

---

What is a periodical index?

974

---

Define normalisation?

1155

---