delete_by_day

declare @tablename varchar(50)select @tablename = 'test'declare @rowName varchar(50)select @rowName = 'date1'declare @n intdeclare @nv varchar(50)select @n = 1declare @flag varchar(50)select @flag = 'dd'declare @ntime datetimedeclare @ntimev varchar(50)select @ntime= getdate()select @ntimedeclare @sql varchar(888)declare @dtime datetimeselect @n = @n - 1select @n = -@nselect @nv = convert(varchar(50),@n)select @ntimev = convert(varchar(50),@ntime)/*select @sql = 'select @dtime = dateadd('+@flag+','+@nv+','''+@ntimev+''')'select @sqlexec (@sql)*/select @dtime = dateadd(dd,0,'1 2 2012  8:08PM') --上一句的结果select @dtime = convert(varchar(50),datepart(yy,@dtime))+'-'+convert(varchar(50),datepart(mm,@dtime))+'-'+convert(varchar(50),datepart(dd,@dtime))select @dtimeselect @sql = 'select * from '+@tablename+' where date1 < '''+convert(varchar(50),@dtime)+''''select @sqlexec (@sql)



	
				
	
					   
delete_by_day
	     		  
	  	   
ifconfig源代码-NetBSD
	  	   
Servlet的应用（九）
	  	   
虚拟机Mac系统 VMware shared Folders被推出后的恢复
	  	   
JSP九大内置对象
	  	   
一. Oracle安装
	  	   
delete_by_day
	  	   
使用CKeditor遇到的问题
	  	   
运行IceGrid demo程序(simple)
	  	   
异常顺序
	  	   
swrdlgc
	  	   
Change Journals
	  	   
Hibernate使用sql语句查询
	  	   
【XEN学习笔记】XEN-3.4.2在Ubuntu 8.04上的编译安装
	  	   
排序算法一（直接选择，堆排序，冒泡排序和快速排序）