Technology
Web App Development
Mobile App Development
Windows App Development
Database Development
UI/UX Development
Cloud Development
SEO
Digital Marketing
Guest Posting
Content Writing
Artificial Intelligence
Data Science
ERP Development
CRM Development
CMS Development
LMS Development
Business Listing
Blockchain Technology
Startup Promotion
AI Tools Integration
Types of cursors :
The Static Cursor – Makes a temporary copy of the data and stores in tempdb and any modifications on the base table do not reflected in data returned by fetches made by the cursor.
The Dynamic Cursor – Reflects all changes in the base table.
The Forward-only Cursor – specifies that cursor can only fetch sequentially from first to last.
The Keyset-driven – A Keyset is the set of keys that uniquely identifies a row is built in a tempdb.