Add variable to TSQL string

Question

This is my SQL command that works

SET @Command = 'REN "C:\Nielsen\' + @FileName + '" "'
+ RIGHT(@FileName,LEN(@FileName)-11) + '"'

I want to replace the C:\Nielsen\ with the value from a variable called @Nielsen

This does not work.....what am I missing?

SET @Command = 'REN ' + @Nielsen + @FileName  
+ RIGHT(@FileName,LEN(@FileName)-11) + ''

EDIT

Error message is:

The syntax of the command is incorrect.

Please define "does not work" - what did you expect, what do you see? — Hans Keﬆing
– Hans Keﬆing, Commented Mar 13, 2013 at 9:29
I am missing something because the error is The syntax of the command is incorrect. — Etienne
– Etienne, Commented Mar 13, 2013 at 9:30
Your first version has a space between @Nielsen and @Filename. Perhaps you need that in your second version as well? — Mikael Eriksson
– Mikael Eriksson, Commented Mar 13, 2013 at 9:33
@etienne - do you get the error on the Set @Command line, or when you execute the command you built (you are missing some " and spaces)? — Hans Keﬆing
– Hans Keﬆing, Commented Mar 13, 2013 at 9:35

Indi · Accepted Answer · 2013-03-13 09:32:44Z

5

You could break it down like below (Sorry formatting doesn't work properly due to escape characters):

--Same string without variable 
SET @Command = 'REN "' + 'C:\Nielsen\' + @FileName + '" "'
+ RIGHT(@FileName,LEN(@FileName)-11) + '"'

--Same string with variable 
SET @Command = 'REN "' + @Nielsen + @FileName + '" "'
+ RIGHT(@FileName,LEN(@FileName)-11) + '"'

answered Mar 13, 2013 at 9:32

Indi

33.9k7 gold badges61 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Add variable to TSQL string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related