关于Sql Srever存储过程 [英] Regarding Sql Srever Stored Procedure

问题描述

嘿每一个......





我们可以在SQL服务器存储过程中编写for循环吗？如果是这样请



给出代码...如果没有请给出任何替代方案



谢谢，

解决方案

您好b $ b

是的当然可以写例如



While Loop：

  DECLARE   @ intFlag   INT  
  SET   @ i  =  1  
  WHILE （ @ i < = 5）
  BEGIN  
  PRINT   @ i  
  SET   @i  =  @ i  +  1  
 结束 
  GO  

从这里 http://stackoverflow.com/questions/4930103/how-to -use-for-loop-in-stored-procedure-sql-server-2005 [ ^ ]你可以找到for循环样本;）



最好的问候。

简单while循环的例子（在存储过程中没有像for循环那样存在）

  DECLARE   @ intFlag   INT  
 
  SET   @ count  =  1  
 
  WHILE （ @ count < = 5）
 
  BEGIN  
 
  PRINT   @ count  
 
  SET   @count  =  @ count  +  1  
 
 < span class =code-keyword> END  
 
  GO  

SQL没有FOR语句，但您可以使用 WHILE-statement [ ^ ]模拟for循环。

  SET  i =  0 ; 
  WHILE （i<  10 ）
 //做你的东西
 
  SET  i = i +  1  
  END  

Hey Every one...


Can we write for-loop in SQL server stored procedure. if so pls

give code...if not Please give any alternatives

Thanks,

解决方案

Hi
Yes of course you can write for example

While Loop:

DECLARE @intFlag INT
SET @i = 1
WHILE (@i <=5)
BEGIN
PRINT @i
SET @i = @i + 1
END
GO

And from here http://stackoverflow.com/questions/4930103/how-to-use-for-loop-in-stored-procedure-sql-server-2005[^] you can find for-loop sample ;)

Best Regards.

Example of simple while loop(Nothing exist like for loop in stored procedures)

DECLARE @intFlag INT

SET @count = 1

WHILE (@count <=5)

BEGIN

PRINT @count

SET @count = @count + 1

END

GO

SQL does not have a FOR-statement, but you can use WHILE-statement[^] to simulate a for loop.

SET i = 0;
WHILE (i < 10)
    // Do your stuff

    SET i = i + 1
END

这篇关于关于Sql Srever存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！