--- Sybase SQL with normalization (NULL→'', trim spaces)
{
echo "SELECT CONVERT(VARCHAR(64), HASHBYTES('MD5',"
echo " STRING_AGG("
for i in "${!COLUMNS_TO_INCLUDE[@]}"; do
[[ $i -gt 0 ]] && echo " + '~' + "
echo "ISNULL(LTRIM(RTRIM(CONVERT(VARCHAR(255), ${COLUMNS_TO_INCLUDE[$i]}))),'')"
done
echo " , '~')))"
echo "FROM $TABLE_NAME"
} > "$TMP_SYB"
Top comments (0)