I have some difficulties using datetime columns, probably I just don't
Suppose I have a table with 2 columns: a date and an integer. The only
thing I want to do is insert a row every day with values current date and
1, and update a row by adding 1 to the integer column.
My problem is that I don't know how to insert just the current date in the
column. Even when using the smalldatetime data type SQL Server inserts the
time that the record was created, and not just the date. When, later that
day, I want to update that record, I can't find it. I want to do something
INSERT INTO Table VALUES ( currentdate, 0 ) and
UPDATE Table Set integervalue = integervalue + 1 WHERE date = currentdate
Can someone help me, please???