11

来源：互联网发布：sqlserver批量删除数据编辑：程序博客网时间：2024/04/30 04:49

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(); 使用游标提取的数据