Sql2008 updating a record

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

Hi,

I am using sql2008 in my project.
In one of my tables one record in 1000 records can not be updated from sql2008 Editing enviroment (In MyTbl Edit Top 200 Row Window) and it makes error, but I can update that record from QueryAnalizer Window (With Sql Commands).

I have no problem with other records in this table.

Can anyone help me with this?

Posted 15-Nov-10 23:37pm

SepantaNima

Updated 15-Nov-10 23:38pm

JF2015

v2

Add a Solution

Comments

JF2015 16-Nov-10 5:39am

What is the error you are facing?

thatraja 17-Nov-10 0:51am

Add the error message in your question

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Corporal Agarn · Answer 1 · 2010-11-18T05:11:00

Solution 1

You can modify the SQL by right clicking the grid then selecting pane SQL.
Use a where clause to narrow the result set.

I am worried that "I can update that record from QueryAnalizer Window". Please provide code and error message as there may be a problem with what you are trying to do.

Posted 18-Nov-10 5:11am

Corporal Agarn

mhwasim · Answer 2 · 2011-05-18T06:30:00

It occurs because when there is no PK or no unique row identification....
Check below example

CREATE TABLE dbo.T
(T VARCHAR(50),
TT VARCHAR(50),
TTT VARCHAR(50)
)

INSERT INTO T
SELECT 'A','AA','AAA' UNION ALL
SELECT 'A','AA','AAA' UNION ALL
SELECT 'B','BB','BBB'

If I want to update the firt value i.e. A it won't allow me from Management Studio coz no unique identification is there....but it will allow me if I modify last one i.e. B

In Queay Analyzer you just provide the criteria which is fine....

Thanks