how to update record to database

Question

5.00/5 (1 vote)

See more:

dear all how to update record to database.
i have database in which i have large no. of row
i want to add column and i want to update all empty rows record for some condition how to add it...
no. of row is 1800.

thank in advance

Posted 4-May-12 20:04pm

DINESH K MAURYA

Add a Solution

2 solutions

Solution 4

You can use T-SQL commands:

ALTER TABLE[^]
UPDATE[^]

Posted 4-May-12 22:59pm

Maciej Los

Add a Solution

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

Sandeep Mewara · Accepted Answer · 2012-05-04T22:27:00

Solution 3

Try the following SQL to add a new column with a default value:

SQL

ALTER TABLE TestTable
ADD NewCol INT NOT NULL DEFAULT(0)
GO

After this, if needed, you can fire an UPDATE query for the table with your specific condition, updating this new column only, like:

SQL

UPDATE TestTable
SET NewCol = Some_Value
WHERE ID=2 
--some condition

Posted 4-May-12 22:27pm

Sandeep Mewara

Comments

P.Salini 5-May-12 5:00am

my 5!

Sandeep Mewara 5-May-12 5:14am

Thanks Salini.

Maciej Los 5-May-12 5:01am

Good answer. My 5!
I was late.... ;)

Sandeep Mewara 5-May-12 5:14am

Thanks losmac.

VJ Reddy 5-May-12 23:19pm

Good answer. +5

Sandeep Mewara 6-May-12 0:55am

Thanks VJ.

how to update record to database

2 solutions

Solution 3

Solution 4

Add your solution here

Preview 0

how to update record to database

2 solutions

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us