sql server 2008 procedure?
I want to declare a variable(example: @x) in a store procedure in sql sever 2008 that save it's value in it for every time we declare the store procedure
what code need to do this????
I want to declare a variable(example: @x) in a store procedure in sql sever 2008 that save it's value in it for every time we declare the store procedure
what code need to do this????
Comments
About the only way I can think of offhand would be to create a table to hold the value between procedure executions. Then you can retrieve the value in the stored procedure each time it's invoked and update it for the next time.