如何根据某些条件显示结果 [英] How to display result based on some condition

问题描述

我的SQL游标中有以下代码，如何根据某些条件打印出结果？例如if条件？

I have the following codes in my SQL Cursor, how can i print out the result based on some conditions? Like for example "if" condition?

DECLARE @sql NVARCHAR(MAX)
	DECLARE @COUNT INT, @status INT
	DECLARE @cursor CURSOR
		
	
	SET @cursor = CURSOR FOR
	SELECT dbo.CRF_Project.DocStatus
	FROM vsCustomizationRequest.dbo.CRF_Project
	WHERE CustomerID = '1'
	
	OPEN @cursor
	FETCH NEXT
	FROM @cursor into @status
	WHILE @@FETCH_STATUS = 0
	BEGIN
		--HERE
		--IF(@status = 0)
                --SET @COUNT = @COUNT + 1
                --PRINT @COUNT
                --I CANT DISPLAY IT OUT 
		FETCH NEXT
		FROM @cursor into @status
		
	END
	CLOSE @cursor
	DEALLOCATE @cursor

推荐答案

这篇关于如何根据某些条件显示结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！