摘要:
select top 12 id, cpmc(产品名称),gsmc(公司名称) from qyzc_cpxx where id in(select id from qyzc_cpxx tb where not exists (select 1 from qyzc_cpxx where hyxx_id=tb.hyxx_id and id>tb.id) and (ycd like '四川%' or... 阅读全文
摘要:
DirectoryInfo dir = new DirectoryInfo(@"C:\DATA"); FileInfo[] finfo = dir.GetFiles(); string fnames = string.Empty; for (int i = 0; i "; } Response.Write(fnames); 阅读全文
摘要:
create trigger UpdateTJ on RCXQ for update as if update(TJ) begin update RCXQ set TJ='0' from RCXQ,inserted where RCXQ.idinserted.id and RCXQ.ZPDW=inserted.ZPDW end 该触发器功能为:如果修改了TJ这个字段的值(一般为1,... 阅读全文