Closing and restarting SSMS seems to be the only way to get rid of the error. After doing so, I can again successfully create the table.

Create the Table with any other name and then rename it works fine. Server refresh did not work for me. You can try to restart Management Studios though.

I was having the same problem.  Right-click on your server connection and select &#39;Refresh&#39;.  I did this and was able to save the recreated table without restarting SSMS.

To change this, on the **Tools** menu, click **Options**, expand **Designers**, and then click **Table and Database Designers**. Select or clear the **Prevent saving changes that require the table to be re-created** check box.

I found that you just need to close all the &#39;delete&#39;s table&#39; TAB from SSMS and it&#39;s done

Make sure that you have no non-saved table changes (better to close all tabulators and try it again)

Right-click on the Server, click on Refresh and try again! Worked like a charm for me. Hope the same works for you as well.

I&#39;ve updated my sdk to the latest version (android 4.4) and I started the emulator, but now it seems not possible to rotate the screen with CTRL+F11, the screen change but all the applications don&#39;t change. I don&#39;t know if it&#39;s a related issue but I can see that even if I created a new emulator with men&#249; hw button, now all the applications have the overflow button.

Impossible to rotate the emulator with android 4.4

So I have a `byte [] array` which I have created in my android app. I want to use SharedPreferences from android to store it and retrieve it back again when I start my app. 
How can I do that ? 


Saving byte array using SharedPreferences

I&#39;ve created a table and then realised I made a mistake. SSMS wouldn&#39;t let me update the table without recreating it, so I&#39;ve deleted the table and then tried to create it again.

It won&#39;t let me do this, and I get an error dialog

&gt; Table &#39;dbo.Foo&#39; already exists.

So I try to delete it again:

    drop table dbo.Foo

&gt; Cannot drop the table &#39;dbo.Foo&#39;, because it does not exist or you do not have permission.

Refreshing the IntelliSense cache does not help.

How can I resolve the &quot;Table &#39;dbo.Foo&#39; already exists.&quot; error when the table does not exist?

I've created a table and then realised I made a mistake. SSMS wouldn't let me update the table without recreating it, so I've deleted the table and then tried to create it again.
It won't let me do this, and I get an error dialog
> Table 'dbo.Foo' already exists.
So I try to delete it again:
<pre><code class="hljs language-sql">drop table dbo.Foo
</code></pre>
> Cannot drop the table 'dbo.Foo', because it does not exist or you do not have permission.
Refreshing the IntelliSense cache does not help.

Sql server table:

    SomeId PK varchar(50) not null 
    OtherId PK int not null


How should I map this in EF 6 code first?


    public class MyTable
    {
        [Key]
        public string SomeId { get; set; }
    
    	[Key]
        public int OtherId { get; set; }
    }


I&#39;ve seen some examples where you have to set the order for each column, is that required?

Is there official documentation on this somewhere?

Mapping composite keys using EF code first

I have a query against a large number of big tables (rows and columns) with a number of joins, however one of tables has some duplicate rows of data causing issues for my query. Since this is a read only realtime feed from another department I can&#39;t fix that data, however I am trying to prevent issues in my query from it.

Given that, I need to add this crap data as a left join to my good query. The data set looks like:

    IDNo	FirstName	LastName	...
    -------------------------------------------
    uqx		bob		smith
    abc		john		willis
    ABC		john		willis
    aBc		john		willis
    WTF		jeff		bridges
    sss		bill		doe
    ere		sally		abby
    wtf		jeff		bridges
    ...

(about 2 dozen columns, and 100K rows)

My first instinct was to perform a distinct gave me about 80K rows:

    SELECT DISTINCT P.IDNo
    FROM people P

But when I try the following, I get all the rows back:

    SELECT DISTINCT P.*
    FROM people P

OR

    SELECT 
        DISTINCT(P.IDNo) AS IDNoUnq 
        ,P.FirstName
        ,P.LastName
        ...etc.    
    FROM people P

I then thought I would do a FIRST() aggregate function on all the columns, however that feels wrong too. Syntactically am I doing something wrong here?

**Update:**
Just wanted to note: These records are duplicates based on a non-key / non-indexed field of ID listed above. The ID is a text field which although has the same value, it is a different case than the other data causing the issue.

SQL Left Join first match only

I have a table with  dates that all happened in the month November.
I wrote this query 

    select id,numbers_from,created_date,amount_numbers,SMS_text 
    from Test_Table
    where 
    created_date &lt;= &#39;2013-04-12&#39;

This query should return everything that happened in month 11 (November) because it happened **before** the date &#39;2013-04-12&#39; (in December)


But it&#39;s only returning available dates that happened in days lesser than 04 (2013-**04**-12)


Could it be that it&#39;s only comparing the day part? and not the whole date?

How to fix this?

Created_date is of type **date**

Date format is by default **yyyy-dd-MM**

Query comparing dates in SQL

I am creating an application that searches the database and allows the user to  dynamically add any criteria (around 50 possible), much like the following SO question: https://stackoverflow.com/q/5541234/810850. I currently have working a search that checks each criteria, and if it is not blank it adds it to the query. 

**C#**
  

    var query = Db.Names.AsQueryable();
      if (!string.IsNullOrWhiteSpace(first))
          query = query.Where(q =&gt; q.first.Contains(first));
      if (!string.IsNullOrWhiteSpace(last))
          query = query.Where(q =&gt; q.last.Contains(last));
      //.. around 50 additional criteria
      return query.ToList();

This code produces something similar to the following in sql server (I simplified for easier understanding)

**SQL**

    SELECT
        [Id],
        [FirstName],
        [LastName],
        ...etc
    FROM [dbo].[Names]
    WHERE [FirstName] LIKE &#39;%first%&#39;
      AND [LastName] LIKE &#39;%last%&#39;
I am now trying to add a way to generate the following SQL with C# through entity framework but with an **OR** instead of an **AND**, while still keeping the ability to add criteria dynamically.

**SQL**

    SELECT
        [Id],
        [FirstName],
        [LastName],
        ...etc
      FROM [dbo].[Names]
    WHERE [FirstName] LIKE &#39;%first%&#39;
      OR [LastName] LIKE &#39;%last%&#39; &lt;-- NOTICE THE &quot;OR&quot;

Usually the criteria wont be larger than two or three items for a query but combining them into one gigantic query is not an option. I have tried concat, union, and intersect and they just all duplicate the query and join them with UNION.

Is there a simple and clean way to add &quot;OR&quot; conditions to a dynamically generated query using entity framework?

**Edit with my solution - 9/29/2015**

Since posting this, I have noticed this has received a little attention, so I decided to post my solution

    // Make sure to add required nuget
    // PM&gt; Install-Package LinqKit
    
    var searchCriteria = new 
    {
    	FirstName = &quot;sha&quot;,
    	LastName = &quot;hill&quot;,
    	Address = string.Empty,
    	Dob = (DateTime?)new DateTime(1970, 1, 1),
    	MaritalStatus = &quot;S&quot;,
    	HireDate = (DateTime?)null,
    	LoginId = string.Empty,
    };
    
    var predicate = PredicateBuilder.False&lt;Person&gt;();
    if (!string.IsNullOrWhiteSpace(searchCriteria.FirstName))
    {
    	predicate = predicate.Or(p =&gt; p.FirstName.Contains(searchCriteria.FirstName));
    }
    
    if (!string.IsNullOrWhiteSpace(searchCriteria.LastName))
    {
    	predicate = predicate.Or(p =&gt; p.LastName.Contains(searchCriteria.LastName));
    }
    
    // Quite a few more conditions...
    
    foreach(var person in this.Persons.Where(predicate.Compile()))
    {
    	Console.WriteLine(&quot;First: {0} Last: {1}&quot;, person.FirstName, person.LastName);
    }

Dynamic query with OR conditions in Entity Framework

I am trying get a day name like friday, saturday, sunday, monday etc from a given date. I know there is a built in function which returns the day name for example:

    SELECT DATENAME(dw,&#39;09/23/2013&#39;) as theDayName 

this SQL query returns:

**&#39;Monday&#39;**

This is all OK. But I would like to pass `Month, Day and Year` individually. 

I am using the builtin DATEPART function to retrieve month, day and year from a date so I can pass it to the DATENAME function:

    SELECT DATEPART(m, GETDATE()) as theMonth  -- returns 11
    SELECT DATEPART(d, GETDATE()) as theDay   -- returns 20
    SELECT DATEPART(yy, GETDATE()) as theYear   -- returns 2013

Now that I have Month, Day, Year values individually, I pass it to my `DATENAME` to get the `Weekname` of the date I want:

    --my SQL query to return dayName
    SELECT (DATENAME(dw, DATEPART(m, GETDATE())/DATEPART(d, myDateCol1)/ DATEPART(yy, getdate())))  as myNameOfDay, FirstName, LastName FROM myTable

This returns an incorrect Day Name. I tried replace / with - so that in the DATENAME function my SQL query becomes:

    SELECT DATENAME(dw,&#39;09/23/2013&#39;) 
    --becomes
    SELECT DATENAME(dw,&#39;09-23-2013&#39;) 
but it still returns incorrect dayName from my SQL query. Am I missing something here.

Please advise.

Get week day name from a given month, day and year individually in SQL Server

I have an existing query that outputs current data, and I would like to insert it into a Temp table, but am having some issues doing so. Would anybody have some insight on how to do this?

Here is an example

    SELECT *
    FROM  (SELECT Received,
                  Total,
                  Answer,
                  ( CASE
                      WHEN application LIKE &#39;%STUFF%&#39; THEN &#39;MORESTUFF&#39;
                    END ) AS application
           FROM   FirstTable
           WHERE  Recieved = 1
                  AND application = &#39;MORESTUFF&#39;
           GROUP  BY CASE
                       WHEN application LIKE &#39;%STUFF%&#39; THEN &#39;MORESTUFF&#39;
                     END) data
    WHERE  application LIKE isNull(&#39;%MORESTUFF%&#39;, &#39;%&#39;) 

This seems to output my data currently the way that i need it to, but I would like to pass it into a Temp Table. My problem is that I am pretty new to SQL Queries and have not been able to find a way to do so. Or if it is even possible. If it is not possible, is there a better way to get the data that i am looking for `WHERE application LIKE isNull(&#39;%MORESTUFF%&#39;,&#39;%&#39;)` into a temp table?

Insert Data Into Temp Table with Query

I have a Table (call it `A_table`) in a database (call it `A_db`) in Microsoft SQL Server Management Studio, and there are 10 rows.

I have another database (call it `B_db`), and it has a Table (call it `B_table`), which has the same column settings as `A_table` has. But the `B_table` is empty.

What I want:

 - **Copy** every rows from `A_table` to `B_table`.

Is there any option in **Microsoft SQL Server Management Studio 2012**, to create an insert SQL from a table? Or is there any other option to do that?

How to export all data from table to an insertable sql format?

In *SQL Server 2012*, &lt;kbd&gt;Ctrl&lt;/kbd&gt;+&lt;kbd&gt;R&lt;/kbd&gt; not working. Any other shortcuts for that.
Any setting changes available or is there any alternative?

Ctrl R not working in SQL Server 2012

When I try to edit table data in SQL Server Management Studio 2008 R2 (right click in table object, Edit Top 200 rows) I receive this error: &quot;Invalid prefix or suffix characters. (MS Visual Database Tools)&quot;. 

Error Invalid prefix or suffix characters in SQL Server Management Studio

I&#39;m wondering if it&#39;s possible to setup SQL Server to have multiple rows of tabs for files / queries. 

I have a lot of queries I want to switch between, and could move them to different horizontal groups, but I think two rows would be much easier to navigate than that pin on the left that drops down the big list of open queries.

Visual Studio kind of supports this if you pin enough code windows to fill up the top bar. 

Is there something similar in SQL Server?

Edit:

I&#39;m trying to achieve something like this (screenshot from Visual Studio)

![Multiple Tabs][1]

While SQL Server is more like this

![Management Studio][2]

  [1]: http://i.stack.imgur.com/Lcsh4.png
  [2]: http://i.stack.imgur.com/dLZeQ.png

Content Type	Original Author	Original Content on Stackoverflow
Question	user247702	View Question on Stackoverflow
Solution 1 - Sql Server	user247702	View Answer on Stackoverflow
Solution 2 - Sql Server	Zoheb	View Answer on Stackoverflow
Solution 3 - Sql Server	user3556018	View Answer on Stackoverflow
Solution 4 - Sql Server	Jafar Mortazavi	View Answer on Stackoverflow
Solution 5 - Sql Server	Sruit A.Suk	View Answer on Stackoverflow
Solution 6 - Sql Server	st35ly	View Answer on Stackoverflow
Solution 7 - Sql Server	Niranjan A	View Answer on Stackoverflow

How can I resolve the "Table 'dbo.Foo' already exists." error when the table does not exist?

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

Solution 2 - Sql Server

Solution 3 - Sql Server

Solution 4 - Sql Server

Solution 5 - Sql Server

Solution 6 - Sql Server

Solution 7 - Sql Server

Saving byte array using SharedPreferences

Impossible to rotate the emulator with android 4.4

Attributions