UPDATE soMetable SET somecolumn = @somevalue WHERE somecolumn = NULL;
@somevalue先前已在脚本中设置.
运行正常,sql告诉我零行受影响.有五行是somecolumn是NULL.我究竟做错了什么？
UPDATE soMetable SET somecolumn = @somevalue WHERE somecolumn IS NULL;
