11

1.extract(month from to_date(p_starttime, 'yyyymmdd'));
2.to_char(
3.trunc(v_count / pagesize)
4.create or replace trigger beforeUpdateService
  before update on greenet_user_service_info 
  for each row
declare
  -- local variables here
begin
 DECLARE
   BEGIN
     IF :new.BIND_PHONE = '1' and :new.username = 'zengf001@163.gd' THEN
          :new.BIND_PHONE := '13760173030' ;
    END IF;
  END;
end beforeUpdateService;

5.v_month := extract(month from to_date(p_starttime, 'yyyymmdd'));
6.DataBinder.Eval(Container.DataItem,"转换的类型","格式")
   DataBinder.Eval(Container.DataItem,"转换的类型")
7.计算器  calc
8.记事本  notepad
9.iis管理器 inetmgr
10.IP地址查看 Nslookup
11.System.Diagnostics.Debug.Write();
12.EventLog.WriteEntry
13.System.Diagnostics.EventLogEntryType.Error
14.System.Diagnostics.Trace.WriteLine(message);
15.Convert.ToString((e.Row.DataItem as System.Data.DataRowView).Row["operatename"]); 使用记录集提取的数据
   (e.Row.DataItem as System.Data.Common.DbDataRecord).GetValue(2).ToString();  使用游标提取的数据