Declare @ProductID int
Declare @Name Nvarchar(50)
Declare @Color Nvarchar(15) 
Declare @ProductNumber Nvarchar(25)

Declare PROD_CURSOR Cursor for
select top 150 ProductID, Name, Color, ProductNumber 
from Production.Product

Open PROD_CURSOR 
Fetch Next From PROD_CURSOR
Into @ProductID, @Name, @Color, @ProductNumber
While @@Fetch_Status = 0 
Begin 
		Print @ProductID
		Print @Name
		If @Color = 'BLACK'
		Print @ProductNumber
		Fetch Next From PROD_CURSOR
		Into @ProductID, @Name, @Color, @ProductNumber
		print @@Fetch_Status
End;
Close PROD_CURSOR
Deallocate PROD_CURSOR