Breaking News: Grepper is joining You.com. Read the official announcement!

while in sql server

Add Answer

Rasel Ahmed answered on March 21, 2021 Popularity 10/10 Helpfulness 3/10

answer while in sql server

related while loop sql

related SQL LOOP WHILE

related while loop in sql

while in sql server

Comment

WHILE (SELECT AVG(ListPrice) FROM Production.Product) < $300  
BEGIN  
   UPDATE Production.Product  
      SET ListPrice = ListPrice * 2  
   SELECT MAX(ListPrice) FROM Production.Product  
   IF (SELECT MAX(ListPrice) FROM Production.Product) > $500  
      BREAK  
   ELSE  
      CONTINUE  
END  
PRINT 'Too much for the market to bear';

Popularity 10/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: sql sql-server

Link to this answer
Share Copy Link

Contributed on Aug 16 2022

Rasel Ahmed

0 Answers Avg Quality 2/10

Closely Related Answers

while loop sql

Comment

/* while loop SQL Server */
DECLARE @Counter INT 
SET @Counter = 1
WHILE (@Counter <= 10)
BEGIN
    PRINT 'The counter value is = ' + CONVERT(VARCHAR, @Counter)
    SET @Counter = @Counter  + 1
END

Popularity 10/10 Helpfulness 10/10 Language sql

Source: www.sqlshack.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Mar 21 2021

VasteMonde

0 Answers Avg Quality 2/10

SQL LOOP WHILE

Comment

-- SQL server  LOOP WHILE

DECLARE @I INT = 0

WHILE @I < 5
BEGIN
    SET @I = @I + 1
        --+++++++++++++++###  START CODE  ###+++++++++++++++--
    
    	SELECT @I
    
  		--+++++++++++++++###  END CODE  ###+++++++++++++++--
END

Popularity 9/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jan 04 2023

Perry Vries

0 Answers Avg Quality 2/10

while loop in sql

Comment

USE DemoDB
GO
CREATE PROCEDURE dbo.Print100
AS
BEGIN
	DECLARE
		@Num int= 1
	WHILE @Num <= 100
	BEGIN
		PRINT(@Num)
		SET @Num = @Num + 1
	END
END

Popularity 9/10 Helpfulness 2/10 Language sql

Source: databasefaqs.com

Tags: sql while-loop while-lo

Link to this answer
Share Copy Link

Contributed on Apr 13 2023

Nanu

0 Answers Avg Quality 2/10

while in sql server

Contents

More Related Answers

while in sql server

Closely Related Answers

while loop sql

SQL LOOP WHILE

while loop in sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.