运行code import os, time import sys import re def search(path, name): for root, dirs, files in os.walk(path): if name in dirs or name in files: flag = 1 root = str(root) dirs = str(dirs) return os.path.join(root) return -1 # find vcvarsall.bat save add
获取存储过程的修改时间和创建时间查询建立时间 --表 select * from sysobjects where id=object_id(N'表名') and xtype='U' --表的结构 select * from syscolumns where id=object_id(N'表名') --存储过程 select * from sysobjects where id=object_id(N'存储过程名') and xtype='P' 查询最后修改时间 --存储过程 select na