Collect and use Session Variable in Stored Procedure
I am very new to creating stored procedures. I understand some of the basics. I need to select records based on a Session Variable. In my db teachers have a Teacher ID (TID) which is stored in Session as the variable TIDSession. I need to retrieve the variable and select records based on the TID. Is this possible? If so what would the code look like? I work in VB. Have VS2008 Pro, and Sql Server 2005.
The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.