sqlserver操作:
建表:create table tablename (columnname )
增加一列: alter table tablename add columnname 字段类型
修改一列: alter table tablename alter column columnname varchar(255)
复制表:insert into 新表名称 from 源表名称 where 1=1;
跨表更新:update table1 set val = (select val from table2 where table1.idd = table2.idd) where exists (select 1 from table2 where table1.idd = table2.idd)
死锁查询:
select
request_session_id spid,
OBJECT_NAME(resource_associated_entity_id) tableName
from
sys.dm_tran_locks
where
resource_type='OBJECT'
结束死锁:
kill spid
Oracle操作:
增加一列:alter table tablename add test varchar2(10);
修改一列:alter table tablename modify test varchar2(20);
删除一列:alter table tablename drop column test;
复制表:create table 新表名称 as select * from 源表名称;
死锁查询:
select username,lockwait,status,machine,program from v$session where sid in
(select session_id from v$locked_object)
结束死锁:
alter system kill session 'sid,serial#'; (其中sid=l.session_id)