Hi Adrian
In SQL Server 6 you could use Date Functions in stored procedures or by
executing script in the enterprise manager. I would say you can still do
this in SQL Server 7.
You should be able to do something like:
UPDATE tablename
SET datefield = DateAdd(yy, 1, datefield)
WHERE whatever-condition-to-meet
HTH
Nick
At 23:08 22/05/00 -0700, you wrote:
>I have a demo system (MSQL7) and want to change all my dates from 1999 to
>2000 and 1998 to 1999.
>
>There must be some SQL code I can use to do this in one shot, any
>recommendations?
>
>-Adrian
>
>
>------------------------------------------------------------------------------
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.