grafana / xk6-sql

k6 extension to load test RDBMSs (PostgreSQL, MySQL, MS SQL and SQLite3)
Apache License 2.0
107 stars 57 forks source link

Example for MS-SQL does not retrieve values properly from SQL Server 2022 #39

Closed leandrodotec closed 1 year ago

leandrodotec commented 1 year ago

sql.query ( ) generates a call to sp_executesql and '$1' is not a valid parameter.

link to sp_executesql documentation:

https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-executesql-transact-sql?view=sql-server-ver16

leandrodotec commented 1 year ago

Btw, the create table and insert statements work just right :-).