The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
53 views

SQLCMD mode: environment variable syntax?

I assume the best way to set my SSMS (SQL Server 2005) output file path during runtime of T-SQL, is to use SQLCMD mode. How do I use environment variables (e.g. %systemroot%) in the code? The ...
-1
votes
1answer
192 views

the environment variables configuration for ORACLE EXPRESS 11g / windows7 32Bit

I can't connect in Oracle Express 11g (windows7 32-bit) and I think the problem comes from the environment variable ORACLE_SID & ORACLE_HOME , how can I get the database instance to do the right ...
2
votes
0answers
750 views

How do I map SSIS 2012 Package Variables to Parameters?

I have created multiple packages that use variables to assign Connection Manager Expressions such as Connection String. However in the new SQL 2012 Project Deployment Model I don't seem to be able to ...
0
votes
1answer
2k views

How to change SESSION_CACHED_CURSORS for all sessions

how Can I do to change SESSION_CACHED_CURSORS for all sessions? I found on google and oracle website: Alter Session... but I need to changed it for all the session and not only for one of them. How ...
2
votes
0answers
72 views

How can I use an environment variable in a Postgres function?

Let's say I have a windows user environment variable SOME_STRING. Is it possible to use its value in a PL/pgSQL function? If not, do I need to use an untrusted language (like PL/pythonu) or can I ...