Importance of While Loop and Table Variable in SQL Server

Sign in to leave a comment.

• RS

  Rakesh S9y agoPosted Sep 22, 2017, 7:22 AM

  Hi, I have requirement that for each row i need to add some number like 100 to 5 rows and next 5 rows will start with first row number + addition of some number.
• LP

  lakshmi prasanna9y agoPosted Jul 6, 2017, 8:53 AM

  I have used while loop in a proc. while executing in sql management studio i am getting records like as you getting. In front end through entityframework i am trying to execute but it is returning only first record.
• RC

  Ritu Chauhan10y agoPosted May 5, 2016, 9:54 AM

  is there a way to print result set in a single table? I have used while loop to iterate through a table using dynamic sql, but haven't found a way to print the results in a single table
• 

  Manish Singh14y agoPosted Mar 17, 2012, 12:17 AM

  It's a good job and it's a really help for beginners.
  • 

    Senthilkumar14y agoPosted Mar 17, 2012, 1:05 AM

    Welcome :-) Manish...
• 

  Amit Maheshwari14y agoPosted Mar 17, 2012, 12:06 AM

  It's a good effort to accomplish such task have a great concept, So keep it up and thanks for sharing.......
  • 

    Senthilkumar14y agoPosted Mar 17, 2012, 1:04 AM

    Welcome amit :-). Trying to write articles that will be practical oriented and reduce the complexity.
• 

  Sudhakar Chaudhary14y agoPosted Mar 16, 2012, 3:22 PM

  are you have any idea to get the index of any item from table without declare auto increment field???
  • 

    Sudhakar Chaudhary14y agoPosted Mar 16, 2012, 11:53 PM

    thanks.
  • 

    Senthilkumar14y agoPosted Mar 16, 2012, 11:24 PM

    ya... you can..The sql server 2005 onwards it supports to use the ROW_NUMBER(). I suggest you to use the CTE. You can use the ROW_NUMBER() inside to get the auto increment field and instead of that CTE will hold the results.