Update date - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Update date

Author

Topic

madhan
Yak Posting Veteran

59 Posts

Posted - 2011-12-14 : 13:03:02

Hi,
DeliveryDate type is smalldatetime. When I try to do the below update

UPDATE [OrdersPDF3 Lab].[dbo].[CustomerOrders]
   SET 
     DeliveryDate = '2011-12-15T00:00:00 ' 
 WHERE customerID=1

I got 0 rows updated. Why? What syntax can I provide to update the deliverydate.
Even I tried DeliveryDate = '2011-12-15’ that didn’t work as well.
Thanks for your help in advance.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-14 : 13:05:44

first check if you've records in your table for customerid=1


SELECT COUNT(*) FROM [OrdersPDF3 Lab].[dbo].[CustomerOrders] WHERE customerID=1

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources