我的论坛主题

• 表中字段的依赖关系

  2008-09-03 14:28:53   /   MS SQL Server

  因为数据出现异常，收到开发同事的需求，要找到对一个表的某一个字段进行更新的所有的存储过程进行检查。记得sp_depends可以察看表的依赖关系是否可以用这个来解决这个需求呢？查了sp_depends的代码,发现可以直接利用select * from (select'sp_name'=object_name(d3.id) ,'name' = (s6.name+ '.' + o1.name),type = substring(v2.name, 5, 16),updated = substring(u4.name, 1, 7),selected = substring(w5.name, 1, 8),'column' = col_name(d3.depid, d3.depnumber)froms

  查看(109) 评论(0)

• 为什么用mysqlhotcopy会有这样的提示信息,但是好象COPY又成功了?

  2008-07-31 14:32:16   /   MySQL及其它开源数据库

  Using copy suffix '_copy'Locked 1 tables in 0 seconds.Flushed tables (`test`.`a`) in 0 seconds.Copying 3 files...shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directoryCopying indices for 0 files...Unlocked tables.mysqlhotcopy copied 1 tables (3 files) in 0 seconds (0 seconds overall).Using copy suffix '_copy'Existing hotcopy directory renamed to '/var/lib/mysql/test_copy_old'Locked 1 tables in 0 seconds.Flu

  查看(218) 评论(2)