ตอนที่ 13 : การ Debug Stored Procedure บน Visual Studio 2010,2012,2013,2015 และอื่น ๆ

CREATE PROCEDURE [dbo].[myStoredProcedure]
	@pRow	INT	
AS
BEGIN
	
	-- Declare Table
	DECLARE @temp TABLE
	(
		RowID INT,
		Name VARCHAR(50),
		LastName VARCHAR(50)
	)

	-- Variable
	DECLARE @i INT
	SET @i = 1

	-- Loop Insert Table
	WHILE (@i <= @pRow)
		BEGIN
			INSERT INTO @temp (RowID,Name,LastName) VALUES ((@i),'Weerachai','Nukitram')
			SET @i = @i + 1 
		END -- WHILE

	-- Variable
	DECLARE @j INT
	DECLARE @iRow INT
	DECLARE @sName VARCHAR(50)
	DECLARE @sLastName VARCHAR(50)

	-- Set Variable
	SET @j = 1
	SELECT @iRow = COUNT(*) FROM @temp

	-- Loop Display Row
	WHILE (@j <= @iRow)
		BEGIN 
			-- Select from table
			SELECT @sName = Name , @sLastName = LastName
			FROM @temp WHERE RowID = @i

			-- Print output
			PRINT ' Row : ' + CONVERT(VARCHAR,@j) + ', Name : ' + @sName + ', LastName : ' + @sLastName
         
		SET @j = @j + 1 
		END -- WHILE

END