Hi all

I want to create a global variable which i want to use in a trigger

can you help me?


thanks

I believe that using SQL 7. and above Global Variables are considered functions. Search Books online for Global variables.

Can you explain on what you are trying to achieve?

To my knowledge Global Variables in sql server are all server defined, all that are prefixed with @@, which cannot be assigned values by a user, but they are assigned values based on activities performed on the server.

Eg: @@ERROR contains ZERO when a last executed transcation is successfully done. Else a non zero value is stored in it.

If you are looking for user defined variables that needs to be global, I am not sure if you can declare something like that in one set of code and use that in another set of code. I don't think that is possible.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

HI,

I feel you have some special purpose and case. If not you can just use @@ to declare a global variable in the way :-

Declare @@MyName Varchar(30)

Once you fired this statement, u have a global variable.

Now you can use it :-

Set @@MyName ='B. Anant'

Select @@MyName as [My Name]
......
.....
....

Hope this helps.

Hi Anant,

I have worked on ur given example but it is not working.
Could you please suggest us a better way.


Thanks,

Lalit
Life Means More...;)

Anant,

I don't think users are let to create global variables with prefix @@. I don't find any document supporting that. Can you confirm if that works as you suggested?

Cheers!

_________________________
- Vijay G
Strive for Perfection