关于Sql Srever存储过程 [英] Regarding Sql Srever Stored Procedure
本文介绍了关于Sql Srever存储过程的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嘿每一个......
我们可以在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屋!
查看全文