Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Using Environment variables in T-SQL

Tags:

sql

sql-server-2005

environment-variables

How can I read the value of a system environment variable in a T-SQL script?

This is to run on SQL Server 2005.

like image 353
benPearce Avatar asked May 13 '09 04:05

benPearce

1 Answers

Hey, if you want to get the server name, just call SELECT @@SERVERNAME

like image 168
Rodrigo Avatar answered Sep 22 '22 15:09

Rodrigo
Sign in to Comment

Related questions

Merge 2 tables in SQL and save into 1 new table
What does COMMIT do?
Order by case insensitive in oracle
What is the correct datatype to store "Worked Hours"
SequelizeJS Soft Deleting
Query with broken sub-select should result in error but returns rows
How I can group the results by day in this query with SQL Server?
MySQL index for MIN and MAX
How do I run md5() on a bigint in Presto?
SQL JOIN with the same table
Linq2DB Nlog or logging
PostgreSQL update row based on the same table
How to programmatically generate the CREATE TABLE SQL statement for a given model in Django?
Getting top rows with the latest related row in joined table quickly
Can you recommend a good source for Teradata Best Practices?
SQL - find next and previous rows given a particular WHERE clause
Best way to get the next id number without "identity"
Select the first row in a join of two tables in one statement
How to write a null safe compare "<=>" in pure SQL?
How to make left outer join a UD-function with any sql table?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!