Forum Discussion
Solved
update the records
Hi Team, This is Bhavsing, I'm new learner of the SQL Server, I have one small doubt that if while we have a all rows with same value then how do we update a different values. Coul...
Its better to have an identity column or a column with a Primary key.
Identity Column -> In SQL Server, an identity column is a special type of column that is commonly used as the primary key of a table. An identity column is a column whose values are generated automatically by the database system, typically incrementing by 1 for each new row added to the table. The purpose of an identity column is to provide a unique, sequential number for each row in the table.
Example -
CREATE TABLE my_table (
id INT IDENTITY(1,1) PRIMARY KEY,
name VARCHAR(50),
age INT
);Update Statement -
UPDATE my_table
SET my_column = 'new_value'
WHERE my_column = 'old_value';You can manually update the same via GUI as well.
Hope it's clear------- If yes, reply and hit like ----- If not reply with your query in more detail----
Hello here is an example:
UPDATE top (1) MyTable
SET emp_Id = '123456'
WHERE emp_id = 1;
Yes you need to have a unique primary keys (A way to identifiy a row uniquely).
Also I'v notice that you have a unique phone...Not ideal primary key for an Employee but you could
update your columns by specifying
Update mytable
set emp_id='123456'
where phone='9000000000'
Hope this helps;)
UPDATE top (1) MyTable
SET emp_Id = '123456'
WHERE emp_id = 1;
Yes you need to have a unique primary keys (A way to identifiy a row uniquely).
Also I'v notice that you have a unique phone...Not ideal primary key for an Employee but you could
update your columns by specifying
Update mytable
set emp_id='123456'
where phone='9000000000'
Hope this helps;)
