SQL - Useful Functions

Get Employees first name:

SELECT SUBSTRING(Name, 1, CHARINDEX(' ', Name)) AS FirstName

System.Web.HttpContext

System.Web.HttpContext.CurrentContext.Response.Write("");

System.Web.HttpContext.Current.User.Identity.IsAuthenticated