存储过程如何反回@Result结果为空
日期：2014-05-17 浏览次数：20682 次
存储过程怎么反回@Result结果为空
CREATE PROCEDURE 存储过程名
@Result VARCHAR(8000) OUTPUT
AS
DECLARE @id INT
DECLARE @Str VARCHAR(8000)
DECLARE Cur CURSOR FOR SELECT [id] FROM [表]
OPEN Cur
WHILE @@FETCH_STATUS=0
BEGIN
FETCH NEXT FROM Cur INTO @id
SET @Str=@Str+','+@id
END
CLOSE Cur
DEALLOCATE Cur
SET @Result=@Str
GO
怎么反回@Result结果为空
------解决方案--------------------
你给@Str赋一个0，没赋初值是null
------解决方案--------------------
CREATE PROCEDURE 存储过程名
@Result VARCHAR(8000) OUTPUT
AS
DECLARE @id INT
DECLARE @Str VARCHAR(8000)
set @Str=''
DECLARE Cur CURSOR FOR SELECT [id] FROM [表]
OPEN Cur
WHILE @@FETCH_STATUS=0
BEGIN
FETCH NEXT FROM Cur INTO @id
SET @Str=@Str+','+@id
END
CLOSE Cur
DEALLOCATE Cur
SET @Result=@Str
GO
------解决方案--------------------
CREATE PROCEDURE 存储过程名
@Result VARCHAR(8000) OUTPUT
AS
DECLARE @id INT
DECLARE @Str VARCHAR(8000)
DECLARE Cur CURSOR FOR SELECT [id] FROM [表]
OPEN Cur
set @Str =''
FETCH NEXT FROM Cur INTO @id
WHILE @@FETCH_STATUS=0
BEGIN
FETCH NEXT FROM Cur INTO @id
SET @Str=@Str+','+@id
END
CLOSE Cur
DEALLOCATE Cur
SET @Result=@Str
GO
------解决方案--------------------
------解决方案--------------------
定义后先赋值，set @Str=''
CREATE PROCEDURE 存储过程名
@Result VARCHAR(8000) OUTPUT
AS
DECLARE @id INT
DECLARE @Str VARCHAR(8000)
DECLARE Cur CURSOR FOR SELECT [id] FROM [表]
OPEN Cur
WHILE @@FETCH_STATUS=0
BEGIN
FETCH NEXT FROM Cur INTO @id
SET @Str=@Str+','+@id
END
CLOSE Cur
DEALLOCATE Cur
SET @Result=@Str
GO
怎么反回@Result结果为空
------解决方案--------------------
你给@Str赋一个0，没赋初值是null
------解决方案--------------------
CREATE PROCEDURE 存储过程名
@Result VARCHAR(8000) OUTPUT
AS
DECLARE @id INT
DECLARE @Str VARCHAR(8000)
set @Str=''
DECLARE Cur CURSOR FOR SELECT [id] FROM [表]
OPEN Cur
WHILE @@FETCH_STATUS=0
BEGIN
FETCH NEXT FROM Cur INTO @id
SET @Str=@Str+','+@id
END
CLOSE Cur
DEALLOCATE Cur
SET @Result=@Str
GO
------解决方案--------------------
CREATE PROCEDURE 存储过程名
@Result VARCHAR(8000) OUTPUT
AS
DECLARE @id INT
DECLARE @Str VARCHAR(8000)
DECLARE Cur CURSOR FOR SELECT [id] FROM [表]
OPEN Cur
set @Str =''
FETCH NEXT FROM Cur INTO @id
WHILE @@FETCH_STATUS=0
BEGIN
FETCH NEXT FROM Cur INTO @id
SET @Str=@Str+','+@id
END
CLOSE Cur
DEALLOCATE Cur
SET @Result=@Str
GO
------解决方案--------------------
CREATE PROCEDURE 存储过程名
@Result VARCHAR(8000) OUTPUT
AS
DECLARE @Str VARCHAR(8000)
SELECT @Str=ISNULL(@Str,',')+LTRIM([id])+',' FROM [表]
SET @Result=@Str
GO
------解决方案--------------------
定义后先赋值，set @Str=''
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
