CODEWITHSUNDEEP
sqlsql-serversql-server-2005t-sqlglobal-variables
Shimmy Weitzhandler
Shimmy Weitzhandler

Reputation: 104781

Create a global static variable in SQL Server?

Is there a way to create a global variable in SQL Server, in such a way that it persists even if the server is restarted, so I can use it in functions?

Example from what I need:

DECLARE @@DefaultValue bit

This variable should never be deleted unless I explicityl do so.

Upvotes: 9

Views: 49241

Answers (4)

Zberteoc
Zberteoc

Reputation: 1

I know is answered but just for fun :)

How about a table with 2 columns like:

GLB_VARIABLES:
GLB_VAR_NAME varchar(100) PRIMARY KEY,
GLB_VAR_VALUE varchar(100)

Upvotes: 0

Shimmy Weitzhandler
Shimmy Weitzhandler

Reputation: 104781

I guess this will work the best for me:

CREATE FUNCTION [dbo].[fn_GetDefaultPercent]()
RETURNS decimal(5,4)
AS
BEGIN
    RETURN 1.0000
END

Upvotes: 10

Adriaan Stander
Adriaan Stander

Reputation: 166486

You can have a look at something like this

"Global variables" in SQL Server

Upvotes: 8

gbn
gbn

Reputation: 432471

Not a global variable.

There's chance you can define a global UDF like you can create a "system" stored proc (starts "sp" in master), but I've not tried it.

Note:

Even DECLARE @@DefaultValue bit is actually local:

@ means local variable, identifier is @DefaultValue

It's not really global: try SELECT @@DefaultValue from 2 another query window

Upvotes: 5

Related Questions