Database

Kukreja Sonu wrote:

Thanks Holmes. As of now we write all the changed data into an XML file at server and upload the same to a centralized location. Then client downloads the xml and executes queries one by one accordingly to update target DB.
But this is a long process:
1. Populating DB at server with change only data
2. Initiate process to prepare XML based on above data.
3. Client downloads the XML and update target DB.
This takes around 3-4 days for single run. So, we want to have some other process if possible to minimize the time

(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