摘要: People p1 = new People() { Age = 10, Name = "张三", Birth = Convert.ToDateTime("1966-10-1") }; People p2 = new People() { Age = 18, Name = "李四", Birth = 阅读全文
posted @ 2022-03-11 10:45 673613920 阅读(361) 评论(0) 推荐(0) 编辑
摘要: 查询表的最大值,并插入新值,新值设置为:最大值 + 1 DECLARE @ID INT SET @ID = (SELECT MAX(ID) FROM dbo.syt) + 1 INSERT dbo.syt ( ID , Name , functionName ) VALUES ( @ID , -- 阅读全文
posted @ 2022-03-11 10:07 673613920 阅读(674) 评论(0) 推荐(0) 编辑