Using Custom List with T-SQL variables but getting '@varName'

#1

I’m using my mockaroo output in SQL Format. I’m pasting it into a large script I have to rebuild my test database. I have a bunch of Custom List using Cartesian and Randoms like
@shopuser1,@shopuser2,@shopuser3,@shopuser4
and
@rw1,@rw2,@rw3,@rw4,@rw5,@rw6,@rw7

I’m setting these variables in a block of T-SQL above where I’m pasting in the insert scripts.

I am hoping to find a way for the data to output without the surrounding 'single quotes'.

I’m hoping my insert statement can look like
values ('0e468940-25b9-4572-80db-6ff624d399f1', @rw1, 0, @shopuser1, ...
until I can sort this out I’m manually removing the 's with column/multi-cursor edits which works but it’s annoying to have to do.

Searched around and couldn’t find any related topics

¯\_(ツ)_/¯

#2

Yes! You can solve this using an inline formula. Click the f(x) button and enter code(this) as the formula. The code function tells Mockaroo that the value should be interpreted as SQL code and not wrapped the value in quotes.

1 Like
#3

Worked like a charm. Very nice!