34,576
社区成员
发帖
与我相关
我的任务
分享自定义用户函数里如何使用while?
while出错...
----------------------------------
CREATE FUNCTION waitorder()
RETURNS nvarchar AS
BEGIN
while(select count(*) from table1)<10
return 'a'
END
----------------------------------
CREATE FUNCTION waitorder()
RETURNS nvarchar AS
BEGIN
while(select count(*) from table1)<10
return 'a'
END
...全文
请发表友善的回复…
发表回复
做鸡真好吃 2006-04-11
- 打赏
- 举报
Mark~
sujinlin 2006-04-11
- 打赏
- 举报
CREATE FUNCTION waitorder()
RETURNS nvarchar(200) AS
BEGIN
DECLARE @i int
DECLARE @Str Nvarchar(200)
Set @Str=''
Set @i=(select count(*) from table1)
while @i<10
begin
Set @i=@i-1
Set @Str=@Str+'a'
end
return @Str
END
RETURNS nvarchar(200) AS
BEGIN
DECLARE @i int
DECLARE @Str Nvarchar(200)
Set @Str=''
Set @i=(select count(*) from table1)
while @i<10
begin
Set @i=@i-1
Set @Str=@Str+'a'
end
return @Str
END
zhaoanle 2006-04-11
- 打赏
- 举报
CREATE FUNCTION waitorder()
RETURNS nvarchar AS
BEGIN
while(select count(*) from table1)<10
begin
...
end
return 'a'
END
--while下不能包含return吧
RETURNS nvarchar AS
BEGIN
while(select count(*) from table1)<10
begin
...
end
return 'a'
END
--while下不能包含return吧
JonasFeng 2006-04-11
- 打赏
- 举报
while下不能接return
chuiyun 2006-04-11
- 打赏
- 举报
关于waitfor出错的问题...
http://community.csdn.net/Expert/topic/4677/4677967.xml?temp=.516369
http://community.csdn.net/Expert/topic/4677/4677967.xml?temp=.516369
chuiyun 2006-04-11
- 打赏
- 举报
晕,CSDN出错结不了贴...
chuiyun 2006-04-11
- 打赏
- 举报
OK!
3Q!!!
3Q!!!
