摘要：DateTime dt = DateTime.Now; //当前时间DateTime startWeek = dt.AddDays(1 - Convert.ToInt32(dt.DayOfWeek.ToString("d"))); //本周周一DateTime endWeek = startWeek 阅读全文

摘要：create table sto (id int not null, -- 主键字段 de datetime -- 被跟踪的字段 constraint pk_sto primary key(id)) select * from sto -- 建日志表create table log_sto(logi 阅读全文

摘要：ALTER TRIGGER [dbo].[tri_test2] ON [dbo].[student] for INSERT,DELETE,UPDATEAS BEGIN if not exists (select * from deleted) --新增 insert student2(stu_id, 阅读全文

摘要：create table tb(name varchar(10),subject varchar(10),mark int) insert into tb values('A', '语文', 80) insert into tb values('A', '数学', 80) insert into t 阅读全文

摘要：LEFT JOIN (SELECT * FROM (SELECT B.BILL_CODE, B.ACK_CODE, ROW_NUMBER() OVER(PARTITION BY B.ACK_CODE ORDER BY B.BILL_CODE) R FROM TAB_BILL_JHD_ACKREL B 阅读全文