Database

(SELECT CONCAT(BFirstName, ' ',  BLastName) FROM CARDINFOPERM WHERE CardID = 1121) AS BAttention

This works, not sure if it's safe
(SELECT CONCAT(BFirstName, ' ',  BLastName)) AS BAttention

SELECT 
    Label
  , CONCAT(BFirstName, ' ',  BLastName) AS BAttention
  , BCity
FROM CardInfoPerm 
WHERE CardID = 1121

jkirkerx wrote:

not sure if it's safe

Quote:

Null values are implicitly converted to an empty string. If all the arguments are null, an empty string of type varchar(1) is returned.

using (var command = new SqlCommand("", connection))
{
    var query = new StringBuilder();
    ...
    query.Append(" SELECT e581_key, 'e581', 'rnlt', rnlt, @rnlt, 'SaveEditRNLT', @logUserName, getdate() ");
    query.Append(" FROM e581 ");
    command.Parameters.AddWithValue("@rnlt", _rnlt);
    command.Parameters.AddWithValue("@logUserName", _logUserName);
    ...
    command.CommandText = query.ToString();
    ...
}

query.Append("SELECT e581_key, 'e581', 'pickup_date', pickup_date , '" + _dateMaterialRequired + "' , 'SaveEditPickup', '" + _logUserName + "', getdate() ");

<pre>

Now _dateMaterialRequired and _timeMaterialRequired are variables, properties, that belong to the to the class that called the hard coded SQL statement. When the SQL is called how are the select statement return values assigned to the variables, properties, that are in the calling code?

holdorf wrote:

how are the select statement return values assigned to the variables, properties, that are in the calling code?

holdorf wrote:

But these values are being filled in by the Where clause.

DBCC SHRINKFILE('your-log-file', 200) -- for 200 MB