如何在sql中将null更新为smalldatetime [英] how update the null into smalldatetime in sql

问题描述

我正在使用sql server而我想将small_date_time更新为null。



我的查询是：UPDATE table_name SET data_info = Null WHERE item = 120 AND job_code = 5



当我在数据库中运行此查询时，它工作正常。



但同样的查询通过vb.net代码运行它也会运行。



但数据库列是得到的最低价值



喜欢：'1/1/1900 12:00:00 AM'



如何能够将列更新为null并提供一些更好理解的示例。

解决方案

如果运行相同的sql;

  UPDATE  table_name  SET  data_info = NULL  WHERE  item = 120  AND  job_code = 5 

将空值插入到您的表中但是如果插入的值为空值<; pre lang =SQL> UPDATE table_name SET data_info = ' ' WHERE item = 120 AND job_code = 5

你最终会得到最短的日期时间：

带参数，你可以设置空值如下

 parameter.Value = DBNull.Value; 

hi,

I'm using sql server and i want update the small_date_time to null .

My query is : UPDATE table_name SET data_info=Null WHERE item=120 AND job_code=5

When i run this query in database it's working fine.

But the same query run via vb.net code it also run.

But the database column is get the minimum value of the date

like :'1/1/1900 12:00:00 AM'

How can i able to update the column to null and give some example for understand better.

解决方案

if you run the same sql;

UPDATE table_name SET data_info=NULL WHERE item=120 AND job_code=5

will insert null values to your table but if you have empty value for insert like ;

UPDATE table_name SET data_info='' WHERE item=120 AND job_code=5

you will end up with minimum datetime:
with parameters, you can set the null value as below

parameter.Value = DBNull.Value;

这篇关于如何在sql中将null更新为smalldatetime的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！