tags:

views:

576

answers:

2

I am new to sharepoint development. I have a list, this list has a column that is called Todaysdate, this column needs to be updated daily to todays accual date and since it contains ~20,000 rows I am NOT going to update it manually everyday. Because it's used in a calculation row.

My question is can I just use SQL and update the rows in the UserData table that correspond to the datetime collumn that I need?

I can querry the list of rows by something simmilar to

Select * from UserData where tp_ListID = 'GUID'

but the data contained in the column datetime3 is not just the Todaysdate information. how do I return just the Todaysdate info?

+2  A: 

You really should not query let alone update the SharePoint content database directly using SQL. It is totally unsupported, so if you break something you are left alone, and the database schema may change with future service packs / releases.
Also as noesgard mentioned it in his comment you do not need it to use today's date in a calculated field, see this blog entry on how you can do that.

csgero
A: 

Here is a blog post that can help you solve your problem.

Toni Frankola