mssql sqsh

mssql_sqsh.sh

#!/usr/bin/env bash
set -euo pipefail
IFS=$'\n\t'
remote="localhost:8999"
remote="web.teignton.htb:1433"
fn="$(mktemp)"
rc="$(mktemp)"
trap "rm -fv \${fn} \${rc}" EXIT

cat <<'EOF' > ${rc}
\set password='xxxxx'
\set username=TEIGNTON.HTB\karl.memaybe
EOF

cat <<'EOF' >/dev/null
select * from openquery("WEB\CLIENTS", 'select * FROM clients..assembly_files');
EOF

cat <<'EOF' > ${fn}
select * from openquery("WEB\CLIENTS", 'SELECT * FROM clients..card_details');
EOF

sqsh -r "${rc}" -S "${remote}" -i "${fn}"