62,046
社区成员
发帖
与我相关
我的任务
分享
yourtable --你的表名
WHERE
yourdate --你的时间
string str = "server='(local)';database='mytable';uid='sa';pwd='sa'";
SqlConnection con = new SqlConnection(str); //创建连接对象
con.Open(); //打开连接
SqlCommand cmd = new SqlCommand("SELECT * FROM yourtable WHERE yourdate < DATEADD(day, -" + drp_date.SelectedValue.ToString() + ", GETDATE())", con);
cmd.ExecuteNonQuery(); //执行SQL命令
con.Close(); //关闭连接
SqlCommand cmd = new SqlCommand("SELECT * FROM yourtable WHERE yourdate < DATEADD(day, -" + drp_date.SelectedValue + ", GETDATE())", con);
CREATE PROC GetAllData ( @selectvalue INT )
AS
BEGIN
SELECT *
FROM yourtable
WHERE yourdate < DATEADD(day, -@selectvalue, GETDATE())
END