How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query.

Answer Posted / nilesh

Update tablename set Column_name = '' where f_name = 'student'

Is This Answer Correct ?    17 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is implicit cursors?

557


How to declare and use cursor variables?

589


Does full backup break log chain?

554


How to get @@error and @@rowcount at the same time?

576


what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

542






how many layers of tcp/ip protocol combined of? : Sql server database administration

532


What do you understand by a view?

559


What is failover clustering overview?

595


What is the use of sign function?

563


Define right outer join in sql server joins?

522


What are the events recorded in a transaction log?

508


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1581


Explain system scalar functions?

583


What is the syntax to execute the sys.dm_db_missing_index_details?

588


How to add more data to the testing table in ms sql server?

556