parameter in stored procedure with apostrophe to quotation marks
CREATE PROCEDURE DB_RESTORE
@DBName varchar(60),
@BackName varchar(120),
@DataName varchar(60),
@DataFileName varchar(120),
@LogName varchar(60),
@LogFileName varchar(120)
AS
RESTORE DATABASE @DBName
FROM DISK = @BackName
WITH REPLACE, MOVE @DataName TO @DataFileName,
MOVE @LogName TO @LogFileName, STATS
GO
If I do it from query analyzer like this it works fine
The problem is when I try to execute it from the code source it takes Test1 between apostrophe like 'Test1' and that is not good.It works only if Test1 is between quotation marks.
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@DBName", OleDbType.VarChar, 60).Value = "Test1";
cmd.Parameters["@DBName"].Direction = ParameterDirection.Input;
cmd.ExecuteNonQuery();
if I trace it with SqlProfiler it looks like this during execution time:
exec[DB_RESTORE] 'Test1', 'F:\Users\Bianca\TEST.BAK', 'BD_Data', 'F:\USERS\DATABASE\BD_Data.MDF', 'BD_Log', 'F:\USERS\DATABASE\BD_Data.LDF'
How can I send Test1 to see it like "Test1" and not 'Test1'

