tSQLt.ResultSetFilter - error when procedure parametr is sql keyword

[blepa]

Hello,

I noticed that when the value of the parameter of tested procedure is equal to the sql keyword - procedure tSQLt.ResultSetFilter returns an error:

System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'AS'.

Test script:

USE tSQLt_Example
GO

IF OBJECT_ID('dbo.uspForTest') IS NOT NULL
DROP PROCEDURE dbo.uspForTest
GO

CREATE PROCEDURE dbo.uspForTest
(
@InParam01 VARCHAR(20)
)
AS
BEGIN
SELECT @InParam01 [InParam01]
ENd
GO

IF OBJECT_ID('dbo.test_uspForTest') IS NOT NULL
DROP PROCEDURE dbo.test_uspForTest
GO

-- ok test case
CREATE PROCEDURE dbo.test_uspForTest
AS
BEGIN

CREATE TABLE #uspForTest
(
InParam01 VARCHAR(20)
)

DECLARE @command VARCHAR(4000)
DECLARE @InParam01 VARCHAR(20)

SET @InParam01 = 'AT'

SET @command = 'EXEC dbo.uspForTest @InParam01 = ' + @InParam01

INSERT INTO #uspForTest
EXEC tSQLt.ResultSetFilter
@ResultsetNo = 1
, @command = @command

SELECT * FROM #uspForTest
END
GO

EXEC tSQLt.Run '[dbo].[test_uspForTest]'
GO

-- error test case
ALTER PROCEDURE dbo.test_uspForTest
AS
BEGIN

CREATE TABLE #uspForTest
(
InParam01 VARCHAR(20)
)

DECLARE @command VARCHAR(4000)
DECLARE @InParam01 VARCHAR(20)

SET @InParam01 = 'AS'

SET @command = 'EXEC dbo.uspForTest @InParam01 = ' + @InParam01

INSERT INTO #uspForTest
EXEC tSQLt.ResultSetFilter
@ResultsetNo = 1
, @command = @command

SELECT * FROM #uspForTest
END
GO

EXEC tSQLt.Run '[dbo].[test_uspForTest]'
GO

[blepa]

Solution:

SET @InParam01 = '''AS'''

Issue to CLOSE.

[mbt1]

This is not a ResultSetFilter issue. But it looks like you figured that out already.