Delete a column value with respect to other

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Delete a column value with respect to other

Author

Topic

Sambhav
Starting Member

31 Posts

Posted - 2007-07-05 : 17:30:35

Hi
I have to delete the value of acktitle where ackby = null
I tried using update but its not helping me i tried doing

update incidents(table name)
set acktitle = null where ackby = null

its not giving me any results thats why i thought of delecting but delete syntax removes the whole row