In Mgmt Studio, when you are editing the top 200, you can view the SQL pane - either by right clicking in the grid and choosing Pane-&gt;SQL or by the button in the upper left.  This will allow you to write a custom query to drill down to the row(s) you want to edit.

But ultimately mgmt studio isn&#39;t a data entry/update tool which is why this is a little cumbersome.

Go to Tools &gt; Options. In the tree on the left, select SQL Server Object Explorer. Set the option &quot;Value for Edit Top &lt;n&gt; Rows command&quot; to 0. It&#39;ll now allow you to view and edit the entire table from the context menu.

If you are on Azure you need you can now, you need to have Manag. Studio 2014 and update hotfix:
http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/12/18/sql-server-2014-management-studio-updated-support-for-the-latest-azure-sql-database-update-v12-preview.aspx

File:
http://hotfixv4.microsoft.com/SQL%20Server%202014/nosp/SQLServer2014_RTM_CU5_3011055_12_0_2456_/12.0.2456.0/free/480863_intl_x64_zip.exe

Brendan is correct.  You can edit the Select command to edit a filtered list of records.  For instance `&quot;WHERE dept_no = 200&quot;`.

This thing is driving me crazy, and the error is quite meaningless to me:

*Unable to update the EntitySet &#39;TableB&#39; because it has a DefiningQuery and no &lt;InsertFunction&gt; element exists in the &lt;ModificationFunctionMapping&gt; element to support the current operation.*

My tables are put like this:

&lt;pre&gt;
TableA
int idA (identity, primary key)
...

TableB
int idA (FK for TableA.idA)
int val
&lt;/pre&gt;

TableB has no defined primary key in the SQL server. The Entity Framework has imported the table and the association and set both fields as key. But it will output that error when I try to do an insert into the table!

What&#39;s wrong??

---

**Edit:** 
As suggested by Alex, the solution was this:

 1. Right click on the edmx file, select Open with, XML editor
 2. Locate the entity in the edmx:StorageModels element
 3. Remove the DefiningQuery entirely
 4. Rename the store:Schema=&quot;dbo&quot; to Schema=&quot;dbo&quot; (otherwise, the code will generate an error saying the name is invalid)
 5. Remove the store:Name property

I left the key as it was, since it was OK to me that both the columns are part of the key.



It has a DefiningQuery but no InsertFunction element... err

I understand the difference between `copy` vs. `deepcopy` in the copy module. I&#39;ve used `copy.copy` and `copy.deepcopy` before successfully, but this is the first time I&#39;ve actually gone about overloading the `__copy__` and `__deepcopy__` methods.  I&#39;ve already Googled around and looked through the built-in Python modules to look for instances of the `__copy__` and `__deepcopy__` functions (e.g. `sets.py`, `decimal.py`, and `fractions.py`), but I&#39;m still not 100% sure I&#39;ve got it right.

Here&#39;s my scenario: 

I have a configuration object.  Initially, I&#39;m going to instantiate one configuration object with a default set of values.  This configuration will be handed off to multiple other objects (to ensure all objects start with the same configuration).  However, once user interaction starts, each object needs to tweak its configurations independently without affecting each other&#39;s configurations (which says to me I&#39;ll need to make deepcopys of my initial configuration to hand around).

Here&#39;s a sample object:

    class ChartConfig(object):
        
        def __init__(self):
            
            #Drawing properties (Booleans/strings)
            self.antialiased = None
            self.plot_style = None
            self.plot_title = None
            self.autoscale = None
            
            #X axis properties (strings/ints)
            self.xaxis_title = None
            self.xaxis_tick_rotation = None
            self.xaxis_tick_align = None
            
            #Y axis properties (strings/ints)
            self.yaxis_title = None
            self.yaxis_tick_rotation = None
            self.yaxis_tick_align = None
            
            #A list of non-primitive objects
            self.trace_configs = []
        
        def __copy__(self):
            pass
        
        def __deepcopy__(self, memo):
            pass 

What is the right way to implement the `copy` and `deepcopy` methods on this object to ensure `copy.copy` and `copy.deepcopy` give me the proper behavior?

How to override the copy/deepcopy operations for a Python object?

Aside from context menu -&gt; &quot;Edit Top 200 Rows&quot; from Object Explorer, is there a quick way to open a table in Edit mode where I can just quickly modify the value of a cell?  

I need to be able to page past the first 200 rows. And I dont want to write &quot;insert&quot; script for every minor tweak I need to do... I don&#39;t understand why SMS doesn&#39;t offer quick access to a paged table editor (like Navicat).

How to quickly edit values in table in SQL Server Management Studio?

<p>Aside from context menu -> "Edit Top 200 Rows" from Object Explorer, is there a quick way to open a table in Edit mode where I can just quickly modify the value of a cell?</p>
<p>I need to be able to page past the first 200 rows. And I dont want to write "insert" script for every minor tweak I need to do... I don't understand why SMS doesn't offer quick access to a paged table editor (like Navicat).</p>


In mysql, can I add a column and foreign key in the same statement?  And what is the proper syntax for adding the fk?

Here is my SQL:

    ALTER TABLE database.table
     ADD COLUMN columnname INT DEFAULT(1),
     FOREIGN KEY (fk_name) REFERENCES reftable(refcolumn) ON DELETE CASCADE;

...and the accompanying error message:

&gt;You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &#39;FOREIGN KEY (fk_name) REFERENCES reftable(refcolumn) ON DELETE CASCADE&#39; at line 4


How to add a column and make it a foreign key in single MySQL statement?

How do I make a composite key with SQL Server Management Studio?

I want two *INT* columns to form the identity (unique) for a table

How do I make a composite key with SQL Server Management Studio?

Can you please help me in solving this problem. I am trying to order the results of an SQL query by date, but I&#39;m not getting the results I need.

The query I&#39;m using is:

    SELECT date FROM tbemp ORDER BY date ASC


Results are:

    01/02/2009
    03/01/2009
    04/06/2009
    05/03/2009
    06/12/2008
    07/02/2009

Results should be:

    06/12/2008
    03/01/2009
    01/02/2009
    07/02/2009

I need to select the date in the format above. 

Your help is much appreciated.


SQL ORDER BY date problem

Just a quick and simple question: in PostgreSQL, how do you list the names of all stored functions/stored procedures using a table using just a SELECT statement, if possible? If a simple SELECT is insufficient, I can make do with a stored function.

My question, I think, is somewhat similar to this other question, but this other question is for SQL Server 2005:&lt;br&gt;
https://stackoverflow.com/questions/119679/list-of-stored-procedure-from-table

(optional) For that matter, how do you also list the triggers and constraints that use the same table in the same manner?

List stored functions that reference a table in PostgreSQL

I have a foreign key constraint in my table, I want to add ON DELETE CASCADE to it.

I have tried this:
&lt;pre&gt;
alter table child_table_name
  modify constraint fk_name
  foreign key (child_column_name)
  references parent_table_name (parent_column_name) on delete cascade;
&lt;/pre&gt;

Doesn&#39;t work.

EDIT:  
Foreign key already exists, there are data in foreign key column.

The error message I get after executing the statement:
&lt;pre&gt;
ORA-02275: such a referential constraint already exists in the table
&lt;/pre&gt;

How to add &#39;ON DELETE CASCADE&#39; in ALTER TABLE statement

I have a file with `.bak` extension.

How can I import this date to a database in SQL Server?



Import .bak file to a database in SQL server

I&#39;m currently searching for an easy way to serialize objects (in C# 3).

I googled some examples and came up with something like:

    MemoryStream memoryStream = new MemoryStream ( );
    XmlSerializer xs = new XmlSerializer ( typeof ( MyObject) );
    XmlTextWriter xmlTextWriter = new XmlTextWriter ( memoryStream, Encoding.UTF8 );
    xs.Serialize ( xmlTextWriter, myObject);
    string result = Encoding.UTF8.GetString(memoryStream .ToArray());

After reading this [question][1] I asked myself, why not using StringWriter? It seems much easier.

    XmlSerializer ser = new XmlSerializer(typeof(MyObject));
    StringWriter writer = new StringWriter();
    ser.Serialize(writer, myObject);
    serializedValue = writer.ToString();

Another Problem was, that the first example generated XML I could not just write into an XML column of SQL Server 2005 DB.

The first question is: Is there a reason why I shouldn&#39;t use StringWriter to serialize an Object when I need it as a string afterwards? I never found a result using StringWriter when googling.

The second is, of course: If you should not do it with StringWriter (for whatever reasons), which would be a good and correct way?

---

Addition:

As it was already mentioned by both answers, I&#39;ll further go into the XML to DB problem.

When writing to the Database I got the following exception:

&gt; System.Data.SqlClient.SqlException:
&gt; XML parsing: line 1, character 38,
&gt; unable to switch the encoding

For string

    &lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;test/&gt;

I took the string created from the XmlTextWriter and just put &lt;test/&gt; as xml there. This one did not work (neither with manual insertion into the DB).

Afterwards I tried manual insertion (just writing INSERT INTO ... ) with encoding=&quot;utf-16&quot; which also failed.
Removing the encoding totally worked then. After that result I switched back to the StringWriter code and voila - it worked.

Problem: I don&#39;t really understand why.

at Christian Hayter: With those tests I&#39;m not sure that I have to use utf-16 to write to the DB. Wouldn&#39;t setting the encoding to UTF-16 (in the xml tag) work then?

  [1]: https://stackoverflow.com/questions/1138414/can-i-serialize-xml-straight-to-a-string-instead-of-a-stream-with-c

Using StringWriter for XML Serialization

I have very simple problem that I can&#39;t solve. I need to do something like this:

    select distinct * from (1, 1, 1, 2, 5, 1, 6).

Anybody can help??

**Edit** 

The data comes as a text file from one of our clients. It&#39;s totally unformatted (it&#39;s a single, very long line of text), but it may be possible to do so in Excel. But it&#39;s not practical for me, because I will need to use these values in my sql query. It&#39;s not convenient to do so every time I need to run a query.

How can I select from list of values in SQL Server

I have a table listing people along with their date of birth (currently a nvarchar(25))

How can I convert that to a date, and then calculate their age in years?

My data looks as follows

    ID    Name   DOB
    1     John   1992-01-09 00:00:00
    2     Sally  1959-05-20 00:00:00


I would like to see:

    ID    Name   AGE  DOB
    1     John   17   1992-01-09 00:00:00
    2     Sally  50   1959-05-20 00:00:00




How to calculate age (in years) based on Date of Birth and getDate()

I&#39;m using using Windows Vista and I&#39;m having trouble logging in with a newly created user.


1. I open SQL Server Management Studio. 
2. I create a new Login by right-clicking on Security-&gt;Logins.  
Check: SQL Server Authentication  
Login name: tester   
Password: test  
Click OK  
3.  I added this user to User Mapping to my database of choice.
4. Click File -&gt; Connect Object Explorer, select SQL Server Authentication and enter tester/test and click Connect.

I get an error:

    Login failed for user &#39;tester&#39;. (Microsoft SQL Server, Error: 18456&quot; 
    with Severity = 14 and State = 1.

What causes this error and how do I login with my user?



SQL Server 2008 can&#39;t login with newly created user

In Microsoft SQL Server Management Studio 2008, is there a secret to be able to edit one row based on a key?

There&#39;s an option to do &quot;Edit Top 200 Rows&quot;, but what if I want to select some other row and edit it in the datagrid? I would rather do that than code an update statement and risk messing up the where clause.

How to edit one specific row in Microsoft SQL Server Management Studio 2008?

Can we see the values (rows and cells) in a table valued variable in SQL Server Management Studio (SSMS) during debug time? If yes, how?

![enter image description here][1]


  [1]: http://i.stack.imgur.com/7Ognh.png

How to see the values of a table variable at debug time in T-SQL?

If I want to save any changes in a table, previously saved in SQL Server Management Studio (no data in table present) I get an error message:

&gt; Saving changes is not permitted. The changes you have made require the
&gt; following tables to be dropped and re-created. You have either made
&gt; changes to a table that can&#39;t be re-created or enabled the option
&gt; Prevent saving changes that require the table to be re-created.

What can prevent the table to be easily edited? Or, is it the usual way for SQL Server Management Studio to require re-creating table for editing? What is it - this **&quot;option Prevent saving changes&quot;**?


Content Type	Original Author	Original Content on Stackoverflow
Question	Xerion	View Question on Stackoverflow
Solution 1 - Sql	brendan	View Answer on Stackoverflow
Solution 2 - Sql	Adam Maras	View Answer on Stackoverflow
Solution 3 - Sql	regisbsb	View Answer on Stackoverflow
Solution 4 - Sql	Paul	View Answer on Stackoverflow

How to quickly edit values in table in SQL Server Management Studio?

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

Solution 4 - Sql

How to override the copy/deepcopy operations for a Python object?

It has a DefiningQuery but no InsertFunction element... err

Attributions