老猫的窝

摘要： Create TRIGGER [dbo].[TRIGGER_dms_rtdb_bjlx] ON [dbo].[dms_rtdb_bjlx] Instead Of INSERTAS BEGIN set nocount on delete dms_rtdb_bjlx where tableno=(SELECT top 1 tableno FROM inserted) insert into dm... 阅读全文

摘要： USE [TEST]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate trigger [dbsafety] on databasefor drop_table,alter_tableas print N'数据库不允许删除或者更改表';rollback;GOSET ANSI_NULLS OFFGOSET QUOTED_IDENTIFIER O... 阅读全文

摘要： CREATE TABLE [dbo].[Table1]( [id] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL, [c1] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL, [c2] [nchar](10) COLLATE Chinese_PRC_CI_AS NULL, [c3] [nchar](10) COLLATE... 阅读全文

摘要： DELETE table1OUTPUT DELETED.* into table2select * from table2 阅读全文

摘要： CString str;char * p;char sz1[256];p = (LPSTR)(LPCTSTR)strstr1 = (LPSTR)(LPCTSTR)sz1; 阅读全文

摘要： struct itemEx { public object Value; public string Text; public itemEx(object value, string text) { this.Value = value; this.Text = text; } //重点是override ToString public override string ToString() { r... 阅读全文

摘要： 1.查看当前模式 select log_mode from v$database; 2.设置init.ora中归档日志的参数 3.关闭数据库：shutdown immediate 4.startup mount 5.alter database archivelog 6.alter database open 阅读全文