.Net Framework, Asp.net, Ado.net, .Net Remoting, .Net Webservice, SQL, XML, XSLT, WCF, WPF, WWF NHibernate, Ajax, Jquery, DHTML

ETG Consultancy

Home

Consultancy

Transaction	XML bulk Insertion into SQL Server
SQL Joins	Cursor
Isolation Level	Difference in procedure & function
Indexing in SQL	SSIS - DTS
Union
Alter in Sql

What is cursor in sql ?
Cursor is a database object, can hold a set of data

Declare Cur_temp Cursor

For

Select GR_GROUP_ID from T_RMGR_GROUP

Open Cur_temp

declare @GR_GROUP_ID int

Fetch NEXT FROM Cur_temp into @GR_GROUP_ID

While (@@FETCH_STATUS <> -1) -- means no error(-1)

begin

print 'record'

select @GR_GROUP_ID as GR_GROUP_ID

Fetch NEXT FROM Cur_temp

end

Close Cur_temp

DEALLOCATE Cur_temp

How many type of cursor there in sql ?
There are 4 types of cursors.
1.forward Only (Default)
2.Static
3.Keyset
4.Dynamic

Asp.net Ajax SQL Developer
Contract base | Hour base | Module base
http://etgconsultancy.com

Web designer in Mumbai
Dhtml, Ajax, Jquery
http://etgconsultancy.com

SEO Consultant in Mumbai
Search Engine Optimization
http://etgconsultancy.com

PHP MySQL Developer
Contract base | Hour base | Module base
http://etgconsultancy.com

Manufacturers In India
Manufacturer Importers Exporters in India & China
http://e-tigers.net

Uk Marketplace
Hotels in london, properties in Uk
http://e-tigers.net/uk

Leave your comment.


Name
Email
Comments
Tell Us	5832+5 =

Reduce your Dialy IT Cost, Consult with us
Stay healthy in recession

Ado.net	Asp.Net 2.0	SQL	C-Sharp	XML	Framework	IIS	XMLWebService	Architecture
UML	Project Management	SDLC	Methodologies	Design Patteren	OOP	WCF	.Net Remoting	WWF
MVP	MVC	Silver Light	N-Hibernate	Ajax	J-Query	SEO-Marketing	Site Map	Php

.Net Framework, Asp.net, Ado.net, .Net Remoting, .Net Webservice, SQL, XML, XSLT, WCF, WPF, WWF NHibernate, Ajax, Jquery, DHTML

Reduce your Dialy IT Cost, Consult with us Stay healthy in recession

Reduce your Dialy IT Cost, Consult with us
Stay healthy in recession