How to call a session variable into sql?

for example, I have a coldfusion session variable - session.testvar

I am writing a Stored procedure in sql server 2000. The query within my stored procedure needs to insert a value into a table. The value needs to be my CF session variable. I have no idea how this is done, does anyone else have a hunch?

I am using coldfusion 8 and sql server 2000.