hello,top buddy.

there are 2 ways:

1:use tools.

http://www.yiii.net/app/servlet/net.yiii.club.DownloadServlet?Information_Id=I00023471

2.since now,you can create a new table

sql: select * into newtable from oldtable where 1 <> 1

then create a trigger on oldtable,every operation...

Hi,topstairs,try like this:

Create Table table1(

DateColumn datetime

)

Select Count(*) From table1 where convert(varchar(8),DateColumn,112) < '20080226'

or

Select Count(*) From table1 where convert(varchar(10),DateColumn,120) < '2008-02-26'

Hi,I'm a new one here.

I need the command the same to you.Did solve it?

there is no response,I've been pullzed for a long time.

Can anyone help me?

Thanks very much.