To get a connection string with SQL Server (t)

In general, C # Connections to SQL Server strings can be directly written directly in the documentation, or you can refer to the famous connectionstrings manual spelling

But if you are already connected to SQL Server you can also get the current connection string in T-sql:

1 SELECT  'server='2         + CONVERT(NVARCHAR( +),ISNULL(Connectionproperty ('local_net_address'),'.'))3         +  Case  whenConnectionproperty ('Local_tcp_port') is NULL  Then "' ELSE ',' END4         + CONVERT(NVARCHAR( +),ISNULL(Connectionproperty ('Local_tcp_port'),"'))+ ';d atabase=' + db_name()5         +  CaseType_desc6              when 'Windows_login'  Then '; Trusted_connection=true'7             ELSE '; uid=' + Suser_name()+ ';p Wd=yourpassword'8           END9  fromsys.server_principalsTen WHEREName= Suser_name()

To get a connection string with SQL Server (t)