For the full list of all of the connection string keywords, including those that are entirely synonymous, please refer to the [`SqlConnection.ConnectionString` documentation][1]:

These are all entirely equivalent:

&gt; * Data Source 
&gt; * Server 
&gt; * Address 
&gt; * Addr 
&gt; * Network Address



  [1]: http://msdn.microsoft.com/en-gb/library/system.data.sqlclient.sqlconnection.connectionstring.aspx

&gt; ... There is no difference between Server and Data Source as they represent the same thing for SQL Server : the full name of the SQL Server instance with the syntax &quot;MyComputerName\MyShortInstanceName&quot; , potentially including the port used by the SQL Server instance to communicate.

Reference: http://social.msdn.microsoft.com/Forums/en/sqldataaccess/thread/7e3cd9b2-4eed-4103-a07a-5ca2cd33bd21

They are synonymous - you can use either one.

That is - as far as the framework is concerned, they are the same.

My favorite set up is one that doesn&#39;t contain any spaces. In the simplest form, one has to provide four values - the URL, the container, the user and the credential.

* server
* database
* uid
* pwd

So a connection string looks like this.

&gt; server=stuffy.databases.net;database=stuffy;uid=konrad;pwd=Abc123(!);


I have version 2.7 installed from early 2012. I can&#39;t find any consensus on whether I should completely uninstall and wipe this version before putting on the latest version.

&quot;Soft&quot;-removing old versions? Hard-removing/wiping old versions? Installing over top?

I&#39;ve seen somewhere a special install/upgrade process using a &quot;segmenting&quot; method of Python installations, keeping different versions separate and apart, but functional. Not sure if this is the standard, de facto way.

I also wonder if Revo gets too overzealous and may cause issues with wiping out still-needed remnants, like environment/PATH variables.

(Win7 x64, 32-bit Python)

How to update Python?

I&#39;m simply trying to access named pandas columns by an integer. 

You can select a row by location using `df.ix[3]`.

But how to select a column by integer?

My dataframe:

    df=pandas.DataFrame({&#39;a&#39;:np.random.rand(5), &#39;b&#39;:np.random.rand(5)})

Selecting pandas column by location

I&#39;m new to SqlServer, right now I have `SqlLocalDb` installed to work locally. Good, but I can see two connection strings typically and both works:

    Data Source=(localdb)\v11.0;Integrated Security=true;

and 

    Server=(localdb)\v11.0;Integrated Security=true;

What exact difference is there between the two?

&quot;Server&quot; vs &quot;Data Source&quot; in connection string

I'm new to SqlServer, right now I have <code>SqlLocalDb</code> installed to work locally. Good, but I can see two connection strings typically and both works:
<pre><code class="hljs language-ini">Data Source=(localdb)\v11.0;Integrated Security=true;
</code></pre>
and
<pre><code class="hljs language-ini">Server=(localdb)\v11.0;Integrated Security=true;
</code></pre>
What exact difference is there between the two?

I&#39;m surprised not to be able to find this question here already.

I have a date time var and I want to convert it to a string so that I can append it to another string. I want it in a format that can be converted easily back to a date time.

How can I do this?

(I want the date part and the time part.)

How to convert a datetime to string in T-SQL

How to recover the unsaved scripts if the SSMS crashes / unsaved tab gets accidentally closed?

Recover unsaved SQL query scripts

Can a `TABLE` have a primary key without a clustered index?

And can a `TABLE` have a clustered index without having a primary key?

Can anybody briefly tell me the relationship between primary key and clustered index?

Relationship of Primary Key and Clustered Index

I need to do select data from a table based on some kind of priority like so:

    select product, price from table1 where project = 1

    -- pseudo: if no price found, do this:
    select product, price from table1 where customer = 2

    -- pseudo: if still no price found, do this:
    select product, price from table1 where company = 3

That is, if I found 3 products with prices based on `project = X`, I don&#39;t want to select on `customer = Y`. I just want to return the resulting 3 rows and be done.

How are you supposed to do stuff like this in SQL? Use some kind of CASE-statement for the pseudo-if&#39;s? Do a union or some other smart thing?

Edit: I&#39;m using MS SQL.

Thanks!

Can you have if-then-else logic in SQL?

I have come to understand that some versions of Microsoft OLE DB Provider for SQL Server (mostly on Windows XP) do not support `WITH` statement. So, I decided to move my SQL statement into a table-valued function, and call it from my application. Now, I&#39;m stuck. How should I use the `INSERT INTO` statement with `WITH`? Here&#39;s the code I have come with so far, but SQL Server doesn&#39;t like it... :-(

    CREATE FUNCTION GetDistributionTable 
    (
    	@IntID int,
    	@TestID int,
    	@DateFrom datetime,
    	@DateTo datetime
    )
    RETURNS 
    @Table_Var TABLE 
    (
    	[Count] int, 
    	Result float
    )
    AS
    BEGIN
    INSERT INTO @Table_Var ([Count], Result) WITH T(Result)
         AS (SELECT ROUND(Result - AVG(Result) OVER(), 1)
             FROM RawResults WHERE IntID = @IntID AND DBTestID = @TestID AND Time &gt;= @DateFrom AND Time &lt;= @DateTo)
    SELECT COUNT(*) AS [Count],
           Result
    FROM   T
    GROUP  BY Result
    	
    	RETURN 
    END
    GO

How to use a CTE statement in a table-valued function in SQL Server

I use `Entity Framework Code First`,

My connection string is in a configuration file:

    &lt;connectionStrings&gt;
        &lt;clear/&gt;
        &lt;add name=&quot;ApplicationServices&quot; connectionString=&quot;Data Source=PC-X;Initial Catalog=MYdb;Integrated Security=True&quot;/&gt;
      &lt;/connectionStrings&gt;

When I try to access the data (something that should create the DB) is falling with the following error:

    

&gt; The connection string &#39;ApplicationServices&#39; in the application&#39;s
&gt; configuration file does not contain the required providerName
&gt; attribute.&quot;

What am I missing?

The connection string &#39;MyConnection&#39; in the application&#39;s configuration file does not contain the required providerName attribute.&quot;

I&#39;m developing a simple C# application, and I&#39;d like to know this: When I connect my application to SQL Server on my PC, I know the connection string (server name, password, etc.), but when I connect it to another PC, the SQL Server connection string is different. Is there a common account in SQL Server that comes with a default account that can connect?

I have heard about the `sa` account in SQL Server. What is `sa`?


How can I set an SQL Server connection string?

I have a web API project which references my model and DAL assemblies. The user is presented with a login screen, where he can select different databases.

I build the connection string as follows:

        public void Connect(Database database)
        {
            //Build an SQL connection string
            SqlConnectionStringBuilder sqlString = new SqlConnectionStringBuilder()
            {
                DataSource = database.Server,
                InitialCatalog = database.Catalog,
                UserID = database.Username,
                Password = database.Password,
            };

            //Build an entity framework connection string
            EntityConnectionStringBuilder entityString = new EntityConnectionStringBuilder()
            {
                Provider = database.Provider,
                Metadata = Settings.Default.Metadata,
                ProviderConnectionString = sqlString.ToString()
            };
        }

First of all, how do I actually change the connection of the data context?

And secondly, as this is a web API project, is the connection string (set at login per above) persistent throughout the user&#39;s interaction or should it be passed every time to my data context?

Entity Framework change connection at runtime

I can invoke `psql` like this:

    psql postgres://...

How can I use `pg_dump` with a connection string in the format `postgres://...`?  
Would be more convenient than breaking URI&#39;s into host, post, username, password.

Is there syntax for this?

How to use pg_dump with a connection uri / url?

For the properties:

    Persist Security Info=true

and

    Persist Security Info=false

Can you tell me what is the difference between them, and if I don&#39;t put it in my connection what will happen?

    connect.ConnectionString = &quot;Provider=Microsoft.ACE.OLEDB.12.0;
                                Data Source=C:/Users/Nourah/Downloads 
                                /Phase3/Salary.accdb; 
                                Persist Security Info=False;&quot;;

Persist Security Info Property=true and Persist Security Info Property=false

I&#39;m following [Code First to an Existing Database](http://msdn.microsoft.com/en-us/data/jj200620) tutorial and noticed that it suggested to connect to `(localdb)\v11.0` in learning purposes. I&#39;ve tried to connect to it using my SQL Management Studio and it worked. But when I&#39;ve restored a DB backup it created an `[DatabaseName].mdf` file in my user&#39;s directory.

I&#39;m quite surprised and have following questions:

 1. What is a `(localdb)\v11.0`? Does it uses my SQL Express or SQL Compact?
 2. Does it support only databases stored in `.mdf` files?
 3. How can I specify path for my restore other than my user&#39;s folder?
 4. What general purposes does it serve (is it for learning purposes only)?
 5. Where can I find more info about this kind of database?

 

SQL Server (localdb)\v11.0 explained

I can&#39;t believe I couldn&#39;t find a working solution to this after an hour of searching. I&#39;m following [this article](http://www.dotnetcurry.com/showarticle.aspx?ID=941) on Entity Framework 6.0 which gives a simple walk-through on Code First. I created the project and installed the latest [EF Nuget package](https://www.nuget.org/packages/EntityFramework/6.0.2) for the project to compile. I also verified that I have Microsoft SQL Server 2012 Express LocalDB installed which came with Visual Studio 2013. I don&#39;t have any other instances of SQL installed on my local computer. The program runs and entries are added to the database and outputted in the console. But when the article says &quot;check your localdb&quot; it doesn&#39;t say how! I don&#39;t see any &#39;.mdf&#39; or &#39;.ldf&#39; files created under the project folder. I tried every way to connect Visual Studio&#39;s Server Explorer to LocalDB. The wizard cannot locate `(localdb)` or cannot find any provider in Server Explorer to accept connection string like `(localdb)\v11.0;Integrated Security=true;` I&#39;ve seen this asked several places in StackOverflow but no answer works or marked as answer. Please help, this doesn&#39;t have to be this frustrating!

What are the steps to connect Visual Studio Server Explorer to LocalDB?

How to connect to LocalDB in Visual Studio Server Explorer?

If I have to work with `localdb`, do we need to install it separately?

I have SQL Server 2008 R2 Management Studio installed, SQL Server 2012 installed, .net 4.0.2 update installed. But I don&#39;t see localdb in the PC yet.

How to install localdb separately?

I&#39;m using SQL Server 2014 Express and the LocalDB option, and I have the following in my SQL Server object explorer pane in Visual Studio 2013...

![enter image description here][1]

  [1]: http://i.stack.imgur.com/ZlDR7.png

So what is the difference between `(localdb)\ProjectsV12` &amp; `(localdb)\MSSQLLocalDB`?

LocalDB SQL Server 2014 Express creates 2 instances (localdb)\ProjectsV12 &amp; (localdb)\MSSQLLocalDB?

### Problem

I don&#39;t understand how to make LocalDB show up in the SQL Server Object Explorer. On some VMs, it shows up automatically, on some other VMs, it doesn&#39;t. Still, after googling for hours, I don&#39;t get it.

### Current situation

1. I have a clean VM
1. I installed Visual Studio 2015 Community (all default settings)
1. I let a console application run (Entity Framework 6, code-first, console application) which worked on another VM and created a database automatically which then showed up in the SQL Server Object Explorer; but not this time

The error says:

    System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.) ---&gt; System.ComponentModel.Win32Exception (0x80004005): The system cannot find the file specified

So, on this VM, no database gets created and nothing shows up in the SQL Server Object Explorer&#39;s `SQL Server` node.

[![Connecting to LocalDB][1]][1]


### What I think to know

- Visual Studio 2015 Community comes with LocalDB; so everything should just work out of the box, but it doesn&#39;t, and I don&#39;t know why
- LocalDB databases are just a pair of files (*.mdf and *.ldf)
- I&#39;ve seen the files being created at the default database location at `C:\Users\&lt;username&gt;\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\MSSQLLocalDB`; but on this VM, there is no such folder
- The `App.config` looked every time like this (and it was automatically created that way when I installed Entity Framework 6 the NuGet Package Manager in Visual Studio):

### App.config

    &lt;configuration&gt;
      &lt;configSections&gt;
        &lt;section name=&quot;entityFramework&quot; type=&quot;System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089&quot; requirePermission=&quot;false&quot; /&gt;
    &lt;/configSections&gt;
      &lt;entityFramework&gt;
        &lt;defaultConnectionFactory type=&quot;System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework&quot;&gt;
          &lt;parameters&gt;
            &lt;parameter value=&quot;mssqllocaldb&quot; /&gt;
          &lt;/parameters&gt;
        &lt;/defaultConnectionFactory&gt;
        &lt;providers&gt;
          &lt;provider invariantName=&quot;System.Data.SqlClient&quot; type=&quot;System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer&quot; /&gt;
        &lt;/providers&gt;
      &lt;/entityFramework&gt;
    &lt;/configuration&gt;

### Other random comments

- Earlier, with SQL Server, it was necessary to open up certain ports, but LocalDB runs, as I understand it, as a separate process on demand when started by Visual Studio.
- I don&#39;t know how to debug the `SQLException`
- Does LocalDB not come packaged with Visual Studio 2015 Community and do I need to install it separately?

  [1]: http://i.stack.imgur.com/NsZiq.png

Content Type	Original Author	Original Content on Stackoverflow
Question	nawfal	View Question on Stackoverflow
Solution 1 - Sql Server	Damien_The_Unbeliever	View Answer on Stackoverflow
Solution 2 - Sql Server	Exel Gamboa	View Answer on Stackoverflow
Solution 3 - Sql Server	Oded	View Answer on Stackoverflow
Solution 4 - Sql Server	Konrad Viltersten	View Answer on Stackoverflow

"Server" vs "Data Source" in connection string

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

Solution 2 - Sql Server

Solution 3 - Sql Server

Solution 4 - Sql Server

Selecting pandas column by location

How to update Python?

Attributions