Skip to content

ErcanOPAK.com

  • ASP.Net WebForms
  • ASP.Net MVC
  • C#
  • SQL
  • MySQL
  • PHP
  • Devexpress
  • Reportviewer
  • About

Tag: cursor

SQL

How to use Nested Cursors in SQL

- 17.08.21 - ErcanOPAK comment on How to use Nested Cursors in SQL

Declare @Parameter1 int; Declare @Parameter2 int; DECLARE Cur1 CURSOR FOR SELECT Column1 From Table1; OPEN Cur1 FETCH NEXT FROM Cur1 INTO @Parameter1; WHILE @@FETCH_STATUS = 0 BEGIN PRINT ‘Processing Column1: ‘ + Cast(@Parameter1 as Varchar); DECLARE Cur2 CURSOR FOR SELECT Column2 FROM Table2 Where Column2 = @Parameter1; OPEN Cur2; FETCH NEXT FROM Cur2 INTO @Parameter2; […]

Read More
SQL

How to solve “A cursor with the name already exists” problem?

- 25.09.19 | 27.11.19 - ErcanOPAK comment on How to solve “A cursor with the name already exists” problem?

If you get this error then it means you are using global cursor that will be defined each time you are calling this procedure and give you the same error. Define a local cursor. Just put the keyword LOCAL after CURSOR: DECLARE MyCursor CURSOR LOCAL FOR … Reference

Read More
November 2025
M T W T F S S
 12
3456789
10111213141516
17181920212223
24252627282930
« Oct    

Most Viewed Posts

  • Get the User Name and Domain Name from an Email Address in SQL (914)
  • Get the First and Last Word from a String or Sentence in SQL (794)
  • How to select distinct rows in a datatable in C# (768)
  • How to add default value for Entity Framework migrations for DateTime and Bool (764)
  • How to make theater mode the default for Youtube (562)
  • Add Constraint to SQL Table to ensure email contains @ (556)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (527)
  • Average of all values in a column that are not zero in SQL (502)
  • Find numbers with more than two decimal places in SQL (417)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (411)

Recent Posts

  • How to get public ip address using Windows PowerShell
  • How to Reset Taskbar in Windows 11
  • Essential Steps to Take After Windows 11 Updates
  • How to list all tables referencing a table by Foreign Key in MS SQL
  • How to format date in Javascript
  • How to generate a random number for each row in T-SQL
  • How to solve ‘Microsoft.TeamFoundation.Git.Contracts.GitCheckoutConflictException’ problem
  • Why nautical mile equals 1852 mt
  • How to Find Day Name From Date in SQL Server
  • How to make pagination in MS SQL Server

Most Viewed Posts

  • Get the User Name and Domain Name from an Email Address in SQL (914)
  • Get the First and Last Word from a String or Sentence in SQL (794)
  • How to select distinct rows in a datatable in C# (768)
  • How to add default value for Entity Framework migrations for DateTime and Bool (764)
  • How to make theater mode the default for Youtube (562)

Recent Posts

  • How to get public ip address using Windows PowerShell
  • How to Reset Taskbar in Windows 11
  • Essential Steps to Take After Windows 11 Updates
  • How to list all tables referencing a table by Foreign Key in MS SQL
  • How to format date in Javascript

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter
© 2025 ErcanOPAK.com | Built with Xblog Plus free WordPress theme by wpthemespace.com