adspace


How to update a field in SQL after ALTERING a row?

Answer Posted / Vivek Yadav

After altering a row in SQL, you can update the field using the UPDATE command. Here's an example:n`UPDATE TableName SET FieldName = 'NewValue' WHERE Condition;`

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we shrink data file in sql server?

1128


Can one drop a column from a table?

1089


What are the different SQL Server Versions you have worked on?

1079


What are wait types?

1249


What is normalization and what are the advantages of it?

1055


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1197


what is spatial nonclustered index

1058


What is the difference between upgrade and migration in sql server?

1184


List out the different types of locks available in sql server?

1050


What is a coalesce function?

1283


How can you append an identity column to a temporary table?

1070


Equi join and non equi join is possible with sql server?

1134


You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1213


Why we use the openxml clause?

1079


What are the source of constraints?

1009