Answer: 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:
SELECT @@SPID
Asked In: Many Interviews |
Alert Moderator