如何删除SQL Server 2005中的特定列值 [英] how to delete a specific column value in sql server 2005

问题描述

查询如何在sql server 2005中删除特定的列值

query for how to delete a specific column value in sql server 2005

推荐答案

请参阅以下链接:

http://www.allinterview.com/showanswers/72884.html [

Refer this link:

http://www.allinterview.com/showanswers/72884.html[^]

您不能完全删除列值.
或者，您可以做的是使用更新语句和
用空白更新值.

You can not exactly delete the column value.
alternatively what you can do is use update statment and
update the value with blank.

update users
set user_adr = ''
where user_id = 'userid'

如果您尝试删除单个列值，则
将单个值更改为NULL或应使用UPDATE语句.

if u trying to delete a single column value then
change a single value to NULL or you should use an UPDATE statement.

这篇关于如何删除SQL Server 2005中的特定列值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！