摘要： protected void btnhuifu_Click(object sender, EventArgs e) { //string path = Page.MapPath("../App_Data").ToString(); //if (new Maticsoft.BLL.Setting().HuiFu(path)) //{ // this.Label1.Text = "数据恢复成功"; //} //else //{ // this.Label1.Text = "数据恢复失败，数据库正在使用"; //} string StrPath = Server.MapPath("../App_ 阅读全文

摘要： DECLARE @temp TABLE( id INT, [name] VARCHAR(50), class VARCHAR(50) ) INSERT INTO @temp SELECT 1,'a','A' UNION ALL SELECT 2,'b','C' UNION ALL SELECT 3,'c','B' UNION ALL SELECT 4,'d','C' UNION ALL SELECT 5,'e','B' UNION ALL SELECT 6,'f','A' SELECT * FROM @temp AS _temp WHERE [name] IN ( SELECT TOP 1 [ 阅读全文