Cursor : Curosr is allow row processing of the result set. Static Dynamic

How many types of cursors are there in SQL Server?

Question Posted / hari

Answer Posted / hari

Cursor : Curosr is allow row processing of the result set.
Static
Dynamic
forward-only
Key setdriven

Is This Answer Correct ?

16 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How can we rewrite sub-queries into simple select statements or with joins?

981

What are the Advantages of using CTE in sql server?

1119

How to provide default values to stored procedure parameters?

1065

What are the advantages of user-defined functions over stored procedures in sql server?

1041

Explain powershell included in sql server 2008?

1055

Describe how to use linked server?

1018

How to include date and time values in sql statements?

1085

Explain about remote stored procedure?

1008

Explain Capacity planning to create a database? and how to monitor it?

4204

Give a example to search fr a string in all stored procedure in sql server.

986

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

1030

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1066

How to call a function from a stored procedure in SQL Server ?

1029

How to concatenate two character strings together?

1121

What is sql server 2000 work load governor?

1064