I have found the problem. When I added the file in VS I forgot to set `Build Action = None` from the file properties. So changing that fixed the problem and the project now compiles.

Regardless this seems to be pretty old I stuck for some hours with that as well and I think this way could be helpful for many.

In `Database project`, files set as `Build` are considered as Database structure so just one statement is allowed in such file by design. `Go` nor any other batch terminator will change that behavior, that message is just mistake.
More info [here.][1]

There is lot of other build options for files in such project.
For your case it seems that `PostDeploy`. In such file you could have various commands like `inserts` etc.

Then you can use output of Database project as dacpac file for Data-Tier DB applications (Otherwise it&#39;s not included).


  [1]: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/47d4124b-82cd-48f9-8ba7-c2ae4c73cbcf/sql71006-why-am-i-getting-this-error?forum=ssdt

I ran into this error when using SQL Server Data Tools and it was because I had a post-deployment script that was added to the project wrong.

In the project file, any database objects should have elements like
```
&lt;Build Include=&quot;dbo\tables\mytable.sql&quot;/&gt;
```

But scripts should have
```
&lt;None Include=&quot;myscript.sql&quot;/&gt;
```

However I added my script file, it ended up with a `Build` tag instead of a `None`. Changing it to `None` fixed the error.

Remove the ;(semi-colon) from last of each statement and I am not sure but GO is not required between above insert statements.

How would I `assertThat` something is `null`?

for example 

     assertThat(attr.getValue(), is(&quot;&quot;));

But I get an error saying that I cannot have `null` in `is(null)`.

How to assertThat something is null with Hamcrest?

I have a variable called `filepath=/tmp/name`.

To access the variable, I know that I can do this: `$filepath`

In my shell script I attempted to do something like this (the backticks are intended)

    `tail -1 $filepath_newstap.sh`

This line fails, duuh!, because the variable is not called `$filepath_newstap.sh`

How do I append `_newstap.sh` to the variable name?

Please note that backticks are intended for the expression evaluation.



Variable interpolation in the shell

I have 4 sql scripts that I want to run in a DACPAC in PostDeployment, but when I try to build the VS project for 3 of them I get this error:

    Only one statement is allowed per batch. A batch separator, such as &#39;GO&#39;, might be required between statements.
The scripts contain only `INSERT` statements in different tables on the DB. And all of them are structured like so

    IF NOT EXISTS (SELECT 1 FROM dbo.Criteria WHERE Name = &#39;Mileage&#39;) INSERT INTO dbo.Criteria(Name) VALUES (&#39;Mileage&#39;);
only on different tables and with different data.

My question is why is VS complaining about 3 of them when all the scripts are the same in terms of syntax and operations?

PS: Adding &#39;GO&#39; between statements as the error suggests doesn&#39;t do anything.

Error in SQL script: Only one statement is allowed per batch

I have 4 sql scripts that I want to run in a DACPAC in PostDeployment, but when I try to build the VS project for 3 of them I get this error:
<pre><code class="hljs language-sql">Only one statement is allowed per batch. A batch separator, such as 'GO', might be required between statements.
</code></pre>
The scripts contain only <code>INSERT</code> statements in different tables on the DB. And all of them are structured like so
<pre><code class="hljs language-sql">IF NOT EXISTS (SELECT 1 FROM dbo.Criteria WHERE Name = 'Mileage') INSERT INTO dbo.Criteria(Name) VALUES ('Mileage');
</code></pre>
only on different tables and with different data.
My question is why is VS complaining about 3 of them when all the scripts are the same in terms of syntax and operations?
PS: Adding 'GO' between statements as the error suggests doesn't do anything.

Here&#39;s what I&#39;m trying to do. Let&#39;s say I have this table t:

    key_id | id | record_date | other_cols
    1      | 18 | 2011-04-03  | x
    2      | 18 | 2012-05-19  | y
    3      | 18 | 2012-08-09  | z
    4      | 19 | 2009-06-01  | a
    5      | 19 | 2011-04-03  | b
    6      | 19 | 2011-10-25  | c
    7      | 19 | 2012-08-09  | d

For each id, I want to select the row containing the minimum record_date. So I&#39;d get:

    key_id | id | record_date | other_cols
    1      | 18 | 2011-04-03  | x
    4      | 19 | 2009-06-01  | a

The only solutions I&#39;ve seen to this problem assume that all record_date entries are distinct, but that is not this case in my data. Using a subquery and an inner join with two conditions would give me duplicate rows for some ids, which I don&#39;t want:

    key_id | id | record_date | other_cols
    1      | 18 | 2011-04-03  | x
    5      | 19 | 2011-04-03  | b
    4      | 19 | 2009-06-01  | a

Group by minimum value in one field while selecting distinct rows

I have a table that contains words and an input field to search that table using a live search. Currently, I use the following query to search the table: 

    SELECT word FROM words WHERE word LIKE &#39;%searchstring%&#39; ORDER BY word ASC

Is there a way to order the results so that the ones where the string is found at the beginning of the word come first and those where the string appears later in the word come last?

An example: searching for &#39;**hab**&#39; currently returns 

 1. **a** lphabet
 2. **h** abit
 3. **r** ehab

but I&#39;d like it this way:

 1. **hab** it      (first because &#39;hab&#39; is the beginning)
 2. alp **hab** et  (second because &#39;hab&#39; is in the middle of the word)
 3. re **hab**      (last because &#39;hab&#39; is at the end of the word)

or at least this way:


 1. **hab** it  (first because &#39;hab&#39; is the beginning)
 2. re **hab**  (second because &#39;hab&#39; starts at the third letter)
 3. alp **hab** et  (last because &#39;hab&#39; starts latest, at the fourth letter)

Would be great if anyone could help me out with this! 

MySQL order by &quot;best match&quot;

I have a simple task where I need to search a record starting with string characters and a single digit after them. What I&#39;m  trying is this

    SELECT trecord FROM `tbl` WHERE (trecord LIKE &#39;ALA[d]%&#39;)

And

    SELECT trecord FROM `tbl` WHERE (trecord LIKE &#39;ALA[0-9]%&#39;)

But both of the queries always return a `null` record 

    trecord
    -------
    null

Where as if I execute the following query

    SELECT trecord FROM `tbl` WHERE (trecord LIKE &#39;ALA%&#39;)

it returns

    trecord
    -------
    ALA0000
    ALA0001
    ALA0002

It means that I have records that starts with ALA and a digit after it,

**EDIT**

I&#39;m doing it using PHP MySQL and innodb engine to be specific.

How to regex in a MySQL query

I&#39;m looking to update multiple rows in PostgreSQL in one statement. Is there a way to do something like the following?

    UPDATE table 
    SET 
     column_a = 1 where column_b = &#39;123&#39;,
     column_a = 2 where column_b = &#39;345&#39;


Update multiple rows in same query using PostgreSQL

I&#39;m trying to create a sub-table from another table of all the last name fields sorted A-Z which have a phone number field that isn&#39;t null. I could do this pretty easy with SQL, but I have no clue how to go about running a SQL query within Excel. I&#39;m tempted to import the data into postgresql and just query it there, but that seems a little excessive. 

For what I&#39;m trying to do, the SQL query `SELECT lastname, firstname, phonenumber WHERE phonenumber IS NOT NULL ORDER BY lastname` would do the trick. It seems too simple for it to be something that Excel can&#39;t do natively. How can I run a SQL query like this from within Excel?

How to run a SQL query on an Excel table?

I am lucky to be an admin of a server, but I have no idea how many versions of sql server on this server. When I opened the file Microsoft SQL Server, there are files called 80, 90, 100, 110. And I have only found SQL Server 2012 setup, so what&#39;s the relationship between the files names like 80, 90, 100, 110 with sql server versions like 2008, 2012?

SQL Server file names vs versions

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

What are the practical differences between COALESCE(&lt;columnName&gt;) and ISNULL(&lt;columnName&gt;,&#39;&#39;)? 

When avoiding NULL values in SQL concatenations, which one is the best to be used?

Thanks!

SQL - Difference between COALESCE and ISNULL?

I want to connect Java class file with SQL server 2012. I have logged in with SQL server authentication, but I am receiving an error when connecting.
 
Error:

&gt; The TCP/IP connection to the host 127.0.0.1, port 1433 has failed.
&gt; Error: &quot;Connection refused: connect. Verify the connection properties.
&gt; Make sure that an instance of SQL Server is running on the host and
&gt; accepting TCP/IP connections at the port. Make sure that TCP
&gt; connections to the port are not blocked by a firewall.&quot;.

My code:

    Class.forName(&quot;com.microsoft.sqlserver.jdbc.SQLServerDriver&quot;);	//1. Register your driver
    //2. get the connection object
    //Connection con = DriverManager.getConnection(&quot;jdbc:sqlserver://localhost;databaseName=aysha&quot;,&quot;sa&quot;,&quot;admin&quot;);
    Connection con = DriverManager.getConnection(&quot;jdbc:sqlserver://127.0.0.1;databaseName=aysha&quot;,&quot;user=sa&quot;,&quot;password=admin&quot;);
     //&quot;jdbc:sqlserver://127.0.0.1:1433; Instance=SQL2008;&quot; +       &quot;databaseName=MB;user=sa;password=123;&quot;;
    //Connection con = DriverManager.getConnection(&quot;jdbc:sqlserver://localhost:1433;databaseName=aysha&quot;,&quot;sa&quot; , &quot;password&quot;);
    //3. Prepare a statement
    Statement stmt = con.createStatement();
    //4. Write the query`
    String sql = &quot;Select * from employee&quot;;
    //5. Execute the statement and 
    ResultSet rs = stmt.executeQuery(sql);
    //6. Process the result set
    
    while (rs.next())
    {
        System.out.println(rs.getInt(1));
    }



JDBC connection failed, error: TCP/IP connection to host failed

I am going to get the list of all users, including Windows users and &#39;sa&#39;, who have access to a particular database in MS SQL Server.
Basically, I would like the list to look like as what is shown in `SQL Server Management Studio` (i.e. the list that is shown when you expand `[databse] -&gt; Security -&gt; Users`) with one important exception: I do not want to see the `&#39;dbo&#39;` in the list. Rather, I would like to see the actual user who owns the database. So, for example, if &#39;sa&#39; is the `&#39;dbo&#39;`, `&#39;sa&#39;` must be included in the list instead of `&#39;dbo&#39;`. Another note not to be missed is, the list in the `SQL Server Management Studio` normally shows Windows users in addition to SQL users, And I would like those users to be included as well.

So far, I have been able to come up with the following query:

    SELECT * FROM sys.database_principals where (type=&#39;S&#39; or type = &#39;U&#39;)

This query is almost right but the problem is it doesn&#39;t satisfy the `&#39;dbo&#39;` condition. 

How can I change this query or should I use another one?

How to get the list of all database users

I&#39;m trying to investigate a bug in a crash dump (so I can not change the code).
I have a really complicated object (thousands of lines in the serialized representation) and its state is inconsistent. To investigate its state the Visual Studio debugger view is useless. But the object has a data contract. I&#39;d like to serialize it and then use my favorite text editor to navigate across the object. Is it possible to do the from the debugger?

Visual Studio how to serialize object from debugger

I&#39;ve searched StackOverflow and found similar problems when I try and open a form that references a UserControl in a different project.

I get the 

&gt; To prevent possible data loss before loading the designer, the following errors must be resolved:

message relating to the following two errors:

&gt; Could not find type &#39;MyNamespace.CommonUi.InformationBox&#39;. Please make
&gt; sure that the assembly that contains this type is referenced. If this
&gt; type is a part of your development project, make sure that the project
&gt; has been successfully built using settings for your current platform
&gt; or Any CPU.


AND

&gt; The variable &#39;InformationBox1&#39; is either undeclared or was never
&gt; assigned.

`InformationBox1` is an instance of the user control `InformationBox` that is on the form in the designer - it&#39;s just referenced as;

    Friend WithEvents InformationBox1 As MyNamespace.CommonUi.InformationBox

The `MyNamespace.CommonUi` project builds successfully.

I get intellisense in the project so I&#39;m reasonably confident that it&#39;s being referenced correctly.

So far, the same as other people have had:

This is a project that&#39;s been migrated from .NET2/x86 in VS2005 to .NET4/x64 in VS2012.

Now when the solution is running under 64 bit it doesn&#39;t work and I get this designer error. However, if I switch it to 32 bit (well technically AnyCPU) I can open the designer just fine.

I&#39;ve read through the other suggestions in similar threads but they don&#39;t see to provide any solution (I&#39;ve even gone as far as the &quot;move it left &amp; right to get it to rebuild&quot; option)

Could not find type &#39;xxx.xxx.xxx&#39;. Please make sure that the assembly

Probably between 25 and 50% of the times I build my solution, I see this:

&quot;[The operation you requested is taking longer than expected to complete. This dialog will close when the action completes.](http://i.imgur.com/UOtXUud.png)&quot;

I hate this window in ways I can&#39;t describe. It never resolves, the Cancel button is never enabled, and the only way to remedy it is to kill the devenv process and load up my entire solution again, knowing full well that I&#39;ve fixed nothing and I&#39;m equally liable to see the same thing when I attempt my build.

My solution is about 60 projects in total, which are mostly C# class libraries, with a few each of web applications, web services, and console applications. However, the problem persists even when building one slice of the codebase with the majority (50) of the projects unloaded.

My problem is that the output windows doesn&#39;t tell me anything at the point at which it freezes, and I don&#39;t know how else to determine the cause of this lockup. If I were to guess, I would assume that it&#39;s a deadlock in the filesystem or something, but I don&#39;t know how to go about proving this--much less how to prevent it.

What can I do to diagnose and eliminate this from my solution so that I never see it again? In general, how can I diagnose problems that occur during a build?

Visual Studio hangs constantly during build

Is there a way to install ASP.NET MVC 5 in Visual Studio 2012?

I&#39;ve tried using NuGet (http://www.nuget.org/packages/Microsoft.AspNet.Mvc). But I think that it should come as a Visual Studio extension, but I can&#39;t find that anywhere.

Or it is available only in Visual&amp;nbsp;Studio&amp;nbsp;2013?


How do I install ASP.NET MVC 5 in Visual Studio 2012?

When I opened my Project in VS2012 , I got an error 

&gt;No exports were found that match the constraint:
&gt;
&gt;   ContractName&lt;br&gt;    Microsoft.VisualStudio.Utilities.IContentTypeRegistryService&lt;br&gt;                           RequiredTypeIdentity&lt;br&gt; Microsoft.VisualStudio.Utilities.IContentTypeRegistryService
&gt;
&gt;Please correct before proceeding. (You might rename the current web.config and add a new one).

Why did this happen, can someone please suggest a solution?

Content Type	Original Author	Original Content on Stackoverflow
Question	Cosmin Ionascu	View Question on Stackoverflow
Solution 1 - Sql	Cosmin Ionascu	View Answer on Stackoverflow
Solution 2 - Sql	Jaroslav Kadlec	View Answer on Stackoverflow
Solution 3 - Sql	JamesFaix	View Answer on Stackoverflow
Solution 4 - Sql	donstack	View Answer on Stackoverflow

Error in SQL script: Only one statement is allowed per batch

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

Solution 4 - Sql

Variable interpolation in the shell

How to assertThat something is null with Hamcrest?

Attributions