Sql update null date

Where something is the string representation of DBNull. What is really uninteresting, because since you have a string literal, the resulting value can never be NULL.

Note that I excluded those brackets. Don't waste your time on typing them. They only serve to make the code more difficult to read. But more generally, you should never built your SQL strings by concatenating values from the client language. Let's say, you wanted to set the column to a value from a textbox. The correct way to do this in VB. Net would be:. Parameterised statements means that: 1 You evade the risk for SQL injection. Sign in. United States English.

Ask a question. Quick access. Search related threads. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 8 years, 2 months ago. Active 2 years, 10 months ago. Viewed 85k times. Improve this question. Manual Manual 1, 5 5 gold badges 16 16 silver badges 20 20 bronze badges. Add a comment. Active Oldest Votes. Improve this answer. I have already tried it, and it is telling me Justin Cave Justin Cave k 22 22 gold badges silver badges bronze badges.

Mihai Mihai Suraj Kumar 5, 8 8 gold badges 19 19 silver badges 39 39 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook.