>The simplest way to answer this question is to check BOL for Raiserror. It clearly states how to use parameters (C++ style) in the string.

I see that the only way to use the variable inside the string as is is to have only the variable. Thus, we have to define the variable entirely at first such as:

DECLARE @Time char(40)

SET @Time='This is the time '+convert(varchar,datepart(hour,getdate()))+':'+
 RIGHT(REPLICATE('0',2)+convert(varchar,datepart(minute,getdate())),2)+':'+
 RIGHT(REPLICATE('0',2)+convert(varchar,datepart(second,getdate())),2)

Raiserror(@Time,0,1) With Nowait

But, the following would not work which I find quite sad:

DECLARE @Time char(40)

SET @Time=convert(varchar,datepart(hour,getdate()))+':'+
 RIGHT(REPLICATE('0',2)+convert(varchar,datepart(minute,getdate())),2)+':'+
 RIGHT(REPLICATE('0',2)+convert(varchar,datepart(second,getdate())),2)

Raiserror('This is the time '+@Time,0,1) With Nowait

So, as I mentioned in the other message, if I wish to use that kind of approach, I then have to use the additional parameters supported by the Raiseerror() to include my variable such as:

DECLARE @Time char(40)

SET @Time=convert(varchar,datepart(hour,getdate()))+':'+
 RIGHT(REPLICATE('0',2)+convert(varchar,datepart(minute,getdate())),2)+':'+
 RIGHT(REPLICATE('0',2)+convert(varchar,datepart(second,getdate())),2)

Raiserror('This is the time %s',0,1,@Time) With Nowait