摘要: use baweigo --select * from student 判断存储过程是否存在if exists(select * from sysobjects where name='up_searchStudent') 如果存在先删除drop proc up_searchStudentgo 创建 阅读全文
posted @ 2018-08-22 20:31 JA~Wang 阅读(162) 评论(0) 推荐(0)
摘要: DAL DAL DAL /// 添加 public int add(info i) { InfoContext ctx = new InfoContext(); ctx.info.Add(i); return ctx.SaveChanges(); } /// 批量删除 public int alld 阅读全文
posted @ 2018-08-22 20:30 JA~Wang 阅读(214) 评论(0) 推荐(0)
摘要: create proc [dbo].[proc_Delete]@TableName varchar(50),@Id varchar(5000)asbegin declare @strSql varchar(5000) declare @sql varchar(4000) set @sql='sele 阅读全文
posted @ 2018-08-18 08:28 JA~Wang 阅读(279) 评论(0) 推荐(0)