You can use Dynamic Sql as shown below in bold (not tested).

>I'm trying to create a stored procedure that will increment all of my datetime values in a database. In my example below I simply attempt to increment all datetime values by 3 months. I'm having some difficulties understanding how to do this in SQL2000, as I'm primarily a VFP developer and am trying to make the adjustment. If I query my database and get a cursor listing all of my DATETIME fields in the database, I'm not sure how to write a simple update which will use the cursor results in an UPDATE command. Here's the meat of my SP so far:
>

>declare fieldlist cursor for
>	select table_name, column_name, data_type
>	from information_schema.columns
>	where DAta_Type = 'datetime'
>
>declare @table AS CHAR(15), @Column AS CHAR(20)
<b>DECLARE @SqlUpdate varchar(1000)</b>
>SET NOCOUNT ON
>
>OPEN fieldlist
>
>FETCH NEXT FROM FieldList
>	INTO @table, @Column
>
>WHILE (@@FETCH_STATUS = 0)
>	BEGIN
    <b>@SqlUpdate = 'UPDATE ' + @table + ' SET ' + 
             @Column + ' = Dateadd(Month,3,' + @column + ')'
    EXECUTE sp_executesql @SqlUpdate </b>

<b>--</b>		UPDATE @table SET @Column = Dateadd(Month,3,@Column)
>		FETCH NEXT FROM FieldList INTO @Table, @Column
>	END
>

>Notice the update command would simply use the results from @table and @column to update the proper fields. In VFP I could use a Macro substitution using the @table and @Column variables, however I'm not sure how to do that in SQL. Any ideas?
>
>Thanks in advance.

You can use parameters with sp_executesql. Take a look if you can use it to your advantage.