用SQL Server(T-SQL)获取连接字符串

SELECT ‘server=‘ 2 + CONVERT(NVARCHAR(40), ISNULL(CONNECTIONPROPERTY(‘local_net_address‘),‘.‘)) 3 + CASE WHEN CONNECTIONPROPERTY(‘local_tcp_port‘) IS NULL THEN ‘‘ ELSE ‘,‘ END 4 + CONVERT(NVARCHAR(40), ISNULL(CONNECTIONPROPERTY(‘local_tcp_port‘),‘‘)) + ‘;database=‘ + DB_NAME() 5 + CASE type_desc 6 WHEN ‘WINDOWS_LOGIN‘ THEN ‘;trusted_connection=true‘ 7 ELSE ‘;uid=‘ + SUSER_NAME() + ‘;pwd=yourpassword‘ 8 END 9 FROM sys.server_principals 10 WHERE name = SUSER_NAME()

 

用SQL Server(T-SQL)获取连接字符串

标签：

本文系统来源：http://www.cnblogs.com/RestlessDeveloper/p/4469492.html

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！