Grabbing the User ID

I’m using Visual Studio 2010. I setup my site security using the Web Site Administration Tool. It stores the user id and user name in a table called aspnet_users.
My question is: If I want to write a stored procedure or query to insert the current user id (which is a unique identifier) into some other table, how do I access the current user ID used in the database?
Thanks
...