SQL server, how to use a string variable?

Question

In the SQL server, how to use a string variable ? for example, I want to write a script to automate database restore, but it complains syntax error near '+' .

how to fix it ?

declare @source varchar(20) = 'Adventureworks2012';
declare @destination varchar(20) = 'Adventureworks2012_copy';

RESTORE DATABASE @source
FROM DISK = @destination
WITH REPLACE, 
MOVE @source+'_Data' TO 'C:\test\Adventureworks2012_20140301_Data.mdf'

Try like @SouceStr varchar(500)= @source+'_Data' and use the concatenated field as Source i.e. MOVE @SouceStr TO 'C:\test\Adventureworks2012_20140301_Data.mdf' — huMpty duMpty
– huMpty duMpty, Commented Feb 19, 2014 at 16:38

Shiva · Accepted Answer · 2014-02-19 16:57:51Z

1

Try something like the following:

DECLARE @Source varchar(50) = 'Adventureworks2012';
DECLARE @Destination varchar(50) = 'Adventureworks2012_copy';
DECLARE @SourceDB varchar(500)
DECLARE @DestinationDB varchar(500)


SET @SourceDB = @Source + '_Data'
SET @DestinationDB = 'C:\test\Adventureworks2012_20140301_Data.mdf'

RESTORE DATABASE @Source
FROM DISK = @Destination
WITH REPLACE, 
MOVE @SourceDB TO @DestinationDB

answered Feb 19, 2014 at 16:57

Shiva

21.1k15 gold badges88 silver badges120 bronze badges

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

Collectives™ on Stack Overflow

SQL server, how to use a string variable?

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