摘要:
select hyid,max(case mdid when 6 then je else 0 end) 春熙店,max(case mdid when 7 then je else 0 end) 全兴店,max(case mdid when 15 then je else 0 end) 天府店,max(case mdid when 8 then je else 0 end) 新馆店from (select mdid,hyid,sum(je) as je from hyxfjl where to_char(xfsj,'yyyymmdd') between 20111203 and 阅读全文
摘要:
更新update computer set computer.ppxh=Sheet1$.型号from computer,Sheet1$where computer.cname=Sheet1$.电脑名 插入insertinto tmp_callin(TOperaName) select ITEMNAME from YW_WORKRECORDTYPE 阅读全文
摘要:
<asp:TemplateField> <EditItemTemplate> <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("hire_date") %>'></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label4" runat="serv... 阅读全文