I set my database to trustworthy and deployed this clr stored proc as unsafe ok but when i run this it returns 1 each time. as if ival keeps getting set back to 0 each time i call this clr stored proc. How to fix so that ival keeps its current value

[DR]

I set my database to trustworthy and deployed this clr stored proc as unsafe
ok but when i run this it returns 1 each time. as if ival keeps getting set
back to 0 each time i call this clr stored proc. How to fix so that ival
keeps its current value each time i execute this from sql server?
public partial class UserDefinedFunc tions
{
static long ival = 0;
[Microsoft.SqlSe rver.Server.Sql Function]
public static long GetTimestampF()
{
return ++ival;
}
};