insert null value into database

Wrox Programmer Forums

		Wrox Programmer Forums > Visual Basic > VB.NET 1.0 > VB.NET 2002/2003 Basics
insert null value into database

VB.NET 2002/2003 Basics For coders who are new to Visual Basic, working in .NET versions 2002 or 2003 (1.0 and 1.1).

Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB.NET 2002/2003 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

August 15th, 2005, 03:15 PM

akibaMaila akibaMaila is offline

akibaMaila is offline

Authorized User

Join Date: Jan 2005

Posts: 30

Thanks: 0

Thanked 0 Times in 0 Posts

Default

insert null value into database

How do I insert a null value into a datetime field in sql server. thanks

Old

August 15th, 2005, 05:44 PM

om_prakash om_prakash is offline

om_prakash is offline

Friend of Wrox

Join Date: May 2004

Posts: 642

Thanks: 0

Thanked 43 Times in 42 Posts

Default

insert into table_name (id,date_column) values (1,null);

This will work if date_column allows null values.

Om Prakash

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Row is null after formview insert??	stapes	ASP.NET 2.0 Basics	1	June 27th, 2008 10:19 AM
how to capture null value(ifpresent) from database	su	C#	6	December 15th, 2006 09:02 AM
BULK INSERT NULL(s)	nathansevugan	SQL Server 2000	2	November 29th, 2005 01:11 AM
Stored Procedure Insert Null Value	harpua	SQL Server ASP	2	March 5th, 2005 10:19 AM
insert null value in MySql?	donh	BOOK: Beginning PHP4/PHP 5 ISBN: 978-0-7645-4364-7; v5 ISBN: 978-0-7645-5783-5	2	November 28th, 2003 11:55 PM