Feedback:

← General

Expose more information as system variables in SQL scripts

Expose more statement and connection metadata via system variables that can be used in SQL scripts.

1 vote
Vote 0 votes Vote Vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Forgot password?
    Create a password
    I agree to the terms of service

    You'll receive a confirmation email with a link to create a password (optional).

    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    jeremym1234jeremym1234 shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Forgot password?
      Create a password
      I agree to the terms of service

      You'll receive a confirmation email with a link to create a password (optional).

      Signed in as (Sign out)
      Close
      Close
      Submitting...
      • pboivin77pboivin77 commented  ·   ·  Flag as inappropriate

        I extend your suggestion to: Allow reading and writing to system variable to change current connection settings. Those change will be lost when the connection is closed.

        SET CHARSET=OEM or ANSI
        SET SHOWDELETED=ON of OFF
        SET DEFAULTTABLETYPE=ADT or DBF
        It could be a stored proc with variables name and value as parameters (e.g. SetSysVariable("ShowDeleted", "ON") ).

      General

      Knowledge Base and Helpdesk

      (thinking…)
      Reset