Skip to main content

Cursors in SQL SERVER

There is one simple example to execute cursors in sql server

  • CREATE TABLE Employee
  • (
  • EmpID int PRIMARY KEY,
  • EmpName varchar (50) NOT NULL,
  • Salary int NOT NULL,
  • Address varchar (200) NOT NULL,
  • )
  • GO
  • INSERT INTO Employee(EmpID,EmpName,Salary,Address) VALUES(1,'Mohan',12000,'Noida')
  • INSERT INTO Employee(EmpID,EmpName,Salary,Address) VALUES(2,'Pavan',25000,'Delhi')
  • INSERT INTO Employee(EmpID,EmpName,Salary,Address) VALUES(3,'Amit',22000,'Dehradun')
  • INSERT INTO Employee(EmpID,EmpName,Salary,Address) VALUES(4,'Sonu',22000,'Noida')
  • INSERT INTO Employee(EmpID,EmpName,Salary,Address) VALUES(5,'Deepak',28000,'Gurgaon')
  • GO
  • SELECT * FROM Employee




  • SET NOCOUNT ON
  • DECLARE @Id int
  • DECLARE @name varchar(50)
  • DECLARE @salary int
  • DECLARE cur_emp CURSOR
  • STATIC FOR
  • SELECT EmpID,EmpName,Salary from Employee
  • OPEN cur_emp
  • IF @@CURSOR_ROWS > 0
  • BEGIN
  • FETCH NEXT FROM cur_emp INTO @Id,@name,@salary
  • WHILE @@Fetch_status = 0
  • BEGIN
  • PRINT 'ID : '+ convert(varchar(20),@Id)+', Name : '+@name+ ', Salary : '+convert(varchar(20),@salary)
  • FETCH NEXT FROM cur_emp INTO @Id,@name,@salary
  • END
  • END
  • CLOSE cur_emp
  • DEALLOCATE cur_emp
  • SET NOCOUNT OFF



  • Thanks :))
    Reference :: http://www.dotnet-tricks.com/Tutorial/sqlserver/4L7I050512-SQL-Server-Basics-of-Cursors.html

    Comments

    Popular posts from this blog

    Snake Xenzia

    Hello friends did you remember the GAME you play on nokia 1100 , SNAKE XENZIA .Yeah the same you are thinking ,a snake eating food and go longer and longer till it dies. Why to play it on mobile when it is available on your pc ??? It is made in .net framework 4.0 .Just install the setup and play SNAKE XENZIA . Have Fun !! DOWNLOAD IT   HERE  . Related articles Rattlesnake Dreams "Classsic Snake Game In C"? Resident Evil 6 gamescom demo takes in a giant snake battle Snakes & ladders

    Export Doc,Access,Image,CSV,Excel,Pdf,XML,HTML,Text,Print of Gridview in Asp.net

    First import itextsharp.dll in the solution and use three namespces (basically for pdf) using iTextSharp.text; using iTextSharp.text.pdf; using iTextSharp.text.html.simpleparser;          Then Use the following code :- on each button  click  protected void Page_Load(object sender, EventArgs e)         {             if (!Page.IsPostBack)             {                 BindGridDetails(GridView1);             }         }                 protected DataTable BindGridDetails(GridView GridView1)         {   ...

    ZORIN OS FOR WINDOWS USERS

    Download(FREE) Zorin OS 6 - Best Linux Distro For Windows User As the dawn of the  Windows 8  era approaches, there are more reasons than ever for longtime Windows users to consider  switching to Linux . Making that switch has never been easier thanks to supremely user-friendly options like  Ubuntu Linux  and Linux Mint , but there's also a lesser-known Linux flavor that's designed specifically to offer an easy transition from Microsoft's operating system. Zorin OS is an Ubuntu-based Linux distribution that actually bills itself as “the gateway to Linux for Windows users.” I wrote about the free and open source operating system once  back in 2010 , but just this week a brand-new version 6 made its debut. If you're accustomed to Windows but are feeling anxious about Windows 8 and all the changes it will bring--or if you're a Linux user who's dissatisfied with the current crop of  desktops  out there--Zorin OS 6 could be just wh...