Using SQL to create, update, and get from Environmental Variables [email protected] (Simon Hutchinson)

​[[{“value”:”Within the latest database PTFs that came as part of the last Technology Refresh were a couple of new Scalar functions that can be used to do things with Environmental Variables. They are name after the APIs that can be used to put and get information from the Environmental Variables. These new SQL Scalar functions are:

PUTENV:  Creates or changes the Environmental Variable. Equivalent of the following commands: ADDENVVAR and CHGENVVAR, and the putenv API
GETENV:  Retrieves the value from the Environmental Variable. Equivalent of the getenv API

Read more »”}]] Read More 

Verified by MonsterInsights