根据楼主的发的access的数据灵感 我终于弄好了SQL（2005测试完好）版本的
数据参数是：
<% @ Import NameSpace="PageAdmin"%>
<% @ Import NameSpace="System.Data"%>
<% @ Import NameSpace="System.Data.OleDb"%>
<% Response.Buffer=true; %>
<%
Conn myconn ;
OleDbConnection myOleDb ;
OleDbCommand comm;
string conPath,sql;
myconn=new Conn();
conPath=myconn.Constr();
myOleDb=new OleDbConnection(conPath);
myOleDb.Open();
sql="UPDATE [information] SET [title_style] ='' where [title_style] NOT LIKE '%color:%' or [title_style] is null";
comm=new OleDbCommand(sql,myOleDb);
comm.ExecuteNonQuery();
sql="UPDATE [information] SET [title_style] = 'background:url(/images/new.gif) no-repeat 100% 0px ; padding: 1px 33px 0px 0px;' WHERE [title_style] NOT LIKE '%color:%' AND [thedate] BETWEEN DateAdd(d, -7, getdate()) AND getdate()";//替换new图标位置，new图标保留几天，改-7这个数字
comm=new OleDbCommand(sql,myOleDb);
comm.ExecuteNonQuery();
myconn=null;
comm=null;
myOleDb.Close();
myOleDb=null;
%>
