Database

• SQL 2005: Not supported.
• SQL 2008: Needs at least SP3.
• SQL 2008 R2:
  
  • Needs at least SP2 on Windows 8.1 / Server 2012 R2;
  • Needs at least SP1 on Windows 8 / Server 2012;
• SQL 2012:
  
  • Needs at least SP1 on Windows 8.1 / Server 2012 R2;
  • No SP required for Windows 8 / Server 2012;
• SQL 2014: No SP required.;

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?