Data can be encrypted using Symmetric or Asymmetric Cryptography keys. Symmetric encryption involves the same key to encrypt as well as to decrypt the message. Both parties communicating the message has to know the key. Key distribution is a problem.
I had a tricky task of getting random ten rows from the table group by a criteria, which was market in my case. I can get the ten random rows by using statement below
SELECT TOP 10 * FROM A ORDER BY NEWID()
The problem for me was
I recently uninstalled and install SQL Server 2008 R2 on my machine. Then, I found out that SQL Agent fails to start. It starts and stops immediately. There were no errors in Event logs or SQL logs. I am unable
A quick code sample to convert object properties into name value string.
/// Converts to a string.
private string ConvertToString(object obj)
var propertyInfos = obj.GetType().GetProperties();
var sb = new StringBuilder();
foreach (var info in propertyInfos)
sb.Append(info.Name + ": ");
var pObj = info.GetValue(obj, null);
foreach (var o in (pObj as IEnumerable))
VBScript allows creating multi-dimensional array which is quite often used as best practice to load recordset in classic asp. However, Multi-dimensional arrays has its own limitation. There is no easy way to query, sort data or even check if the