返回/结果字符串的存储过程

CREATE PROCEDURE GetVehicleInfo 
@CustId INT 
OUTPUT AS

  RETURN (SELECT \'Your vehicle # is \' + id + \' with ETA in \' + ETA + \' minutes\' 
          FROM YourTable WHERE CustId = @CustId )

GO

SELECT \'whatever string you want to put\' + columnName + \' whatever...\' FROM @result

select \'Your vehicle # is \' + vehiclenum + \' with ETA in \' eta \' minutes\' from table_1
where your_select_criteria

select \'Your vehicle # is \' + convert(varchar(10), vehiclenum) + \' with ETA in \' eta \' minutes\' 
from table_1
where your_select_criteria

var outputText = cmd.ExecuteScalar();