What is meant by SQL session ?

 Posted by Bharathi Cherukuri on 7/24/2012 | Category: Sql Server Interview questions | Views: 1516 | Points: 40

If a user is connected to the database initially, then a session will be established.
While the user is in session, he can use any of the SQL commands. He can manipulate data in the database, and can define database structures such as tables.
Each SQL session is associated with a user identifier and role name.

Example to get the session ID,type:


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response