As you parse the UserAgent string in the server-side VB.NET or C#.NET code, it is possible to parse it using T-SQL programming. This would be extremely useful when your web application is more SQL Server dependant - having most of the business logic as stored procedures and functions. The only difference here is, as in ASP.NET, the UserAgent string is not accessible directly inside T-SQL context, but you need to pass the string from your ASP.NET calling method as a parameter to your stored procedure query.

For more information on UserAgent string, you could read the ASP.NET article Snippet: Get Browser Name from UserAgent String.

What we intend to do here, is to extract the browser name as well as the version. In some cases, like Internet Explorer, this is quite simple - just to look for existence of a regular phrase MSIE 6.0 or MSIE 8.0. But with other browsers, this is not simple because the browser name and version would not be place together, or the version would have more details with minor build number, etc., there may be different version numbers of different sub-components. So for each browser, you have to use a different extraction technique to extract the proper Browser Name and Version.

The TSQL function would look like this:

You can improve this function by adding processing code for more kinds of browsers, or even for bots like GoogleBot, etc.