script_postgres.exs

Mix.install([
  {:postgrex, "~> 0.15.0"}
])

{defmodule MyMod do
  def main do
    {:ok, pid} =
      Tds.start_link(
        hostname: "localhost",
        username: "sa",
        password: "io",
        database: "master",
        port: 1443
      )
      
    # IO.inspect(Tds.query!(pid, "SELECT * from information_schema.tables ", []))
    # IO.inspect(Tds.query!(pid, "SELECT * from information_schema.tables where table_catalog = @1 ", ["master"]))
    IO.inspect(
      Tds.query!(pid, "SELECT * from information_schema.tables where table_catalog = @tbl ", [
        %Tds.Parameter{name: "@tbl", value: "master"}
      ])
    )
  end
end

MyMod.main()

script_tds.exs

Mix.install([
  {:tds, "~> 2.0"}
])

# alias Tds.Parameter

{:ok, pid} =
  Tds.start_link(
    hostname: "localhost",
    username: "sa",
    password: "io",
    database: "master",
    port: 1443
  )

# IO.inspect(Tds.query!(pid, "SELECT * from information_schema.tables ", []))
# IO.inspect(Tds.query!(pid, "SELECT * from information_schema.tables where table_catalog = @1 ", ["master"]))
IO.inspect(
  Tds.query!(pid, "SELECT * from information_schema.tables where table_catalog = @tbl ", [
    %Tds.Parameter{name: "tbl", value: "master"}
  ])
)