Home Forums SQL Server 2008 T-SQL (SS2K8) How to parse connection strings on a column in SQL Server 2008 RE: How to parse connection strings on a column in SQL Server 2008

  • November 28, 2013 at 11:48 am

    #1669716

    Found it.

    SELECT

    substring(substring(dbconnection,CHARINDEX('Database=',dbconnection)+9, LEN(dbconnection)),1,CHARINDEX(';',substring(dbconnection,CHARINDEX('Database=',dbconnection)+9, LEN(dbconnection)))-1)

    FROM Connections

    Thanks,

    Kuzey