Static variables

[DomTrix]

How can you set static variables in enterprise manager? I think 'static variables' is the correct term. Basically, I would like to do something like:

SELECT blah
FROM tableBlah
WHERE blahID = @@myStaticBlahID

Can I create and set these @@ variables in EM?

Thanks in advance

DT

 

[SQLDenis]

use a userdefined function for this and hard code the value in there

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[DomTrix]

Ok thankyou,

I am new to anything but SPs and general db design. Could you give me an example of how I might implement this (or soewhere where there is an example, can't find anything on google or here)? Would the UDF need calling to define the variable...?

DT

 

[SQLDenis]

create FUNCTION dbo.GetID()
RETURNS INT
BEGIN
DECLARE @ID INT
SET @ID =1
RETURN (@ID)
END

--select dbo.GetID()


SELECT blah
FROM tableBlah
WHERE blahID = dbo.GetID()

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[DomTrix]

Oh i see, great thankyou