grep 用法介绍
来源:互联网 发布:python获取交集 编辑:程序博客网 时间:2024/04/30 08:38
gateman@GPC:~/shell/SQL_GSI$ grep OID a.sql
WHERE OID=@BuildNOWHERE OID INWHERE OID=@BuildNOWHERE OID IN
gateman@GPC:~/shell/SQL_GSI$ grep ^WHERE a.sql
WHERE BuildNO=@BuildNO AND Year=@Year AND Money=@Money AND Level=@LevelWHERE OID=@BuildNOWHERE SHIP INWHERE OID INWHERE DeptPersonStatus=@BuildNO AND Year=@Year AND Work_Time=@WorkTime AND Level=@LevelWHERE OID=@BuildNOWHERE SHIP INWHERE OID INWHERE Year=@Year AND Level=@LevelWHERE Level=@Level
WHERE BuildNO=@BuildNO AND Year=@Year AND Money=@Money AND Level=@Level
/*建造规划版本表最新修改时间*/
SELECT @Max_BVer=MAX(UpdateTime)
--
WHERE OID=@BuildNO
/*号船进度预测的最新修改时间*/
SELECT @Max_SProgress=MAX(UpdateTime)
--
WHERE SHIP IN
(SELECT SHIP
FROM BuildSchedule
WHERE BuildNo=@BuildNO
--.........(仲有)
587:WHERE OID=@BuildNO915:WHERE OID IN2152:WHERE OID=@BuildNO2496:WHERE OID IN
gateman@GPC:~/shell/SQL_GSI$ grep -c OID a.sql
4gateman@GPC:~/shell/SQL_GSI$ grep -c -v OID a.sql155gateman@GPC:~/shell/SQL_GSI$ grep -c "OID" CreateFunction.sql a.sqlCreateFunction.sql:4
a.sql:4
/****** 对象: 用户定义的函数 dbo.CheckShipSales 脚本日期: 2010-7-23 10:47:27 ******/ CREATE FUNCTION dbo.CheckShipSales (@BuildNO INT,@Year INT,@Money INT,@Level INT) -- DECLARE @Min_SSales AS DATETIME DECLARE @Max_BVer AS DATETIME -- /*ShipSales最早修改时间*/ SELECT @Min_SSales=MIN(UpdateTime) FROM ShipSales WHERE BuildNO=@BuildNO AND Year=@Year AND Money=@Money AND Level=@Level -- IF @Min_SSales>=@Max_BVer AND @Min_SSales>=@Max_SProgress AND @Min_SSales>=@Max_Ship BEGIN -- DECLARE @Min_SSales AS DATETIME DECLARE @Max_BVer AS DATETIME -- SELECT @Min_SSales=MIN(UpdateTime) FROM DeptPersonStatus --
./SQL_GSI/CreateProcedure.txt:45: S.ODock=D.OID AND S.OShip=BS.OID AND
./SQL_GSI/CreateFunction.sql:20:WHERE OID=@BuildNO
./SQL_GSI/CreateFunction.sql:34:WHERE OID IN
./SQL_GSI/CreateFunction.sql:87:WHERE OID=@BuildNO
./SQL_GSI/CreateFunction.sql:101:WHERE OID IN
./SQL_GSI/a.sql:20:WHERE OID=@BuildNO
./SQL_GSI/a.sql:34:WHERE OID IN
./SQL_GSI/a.sql:87:WHERE OID=@BuildNO
./SQL_GSI/a.sql:101:WHERE OID IN
./SQL_GSI/folder01/b.sql:20:WHERE OID=@BuildNO
./SQL_GSI/folder01/b.sql:34:WHERE OID IN
./SQL_GSI/folder01/b.sql:87:WHERE OID=@BuildNO
./SQL_GSI/folder01/b.sql:101:WHERE OID IN
。。。。。。。。。。。。。。。。
gateman@GPC:~/shell/SQL_GSI$ grep -H OID a.sql folder01/b.sqla.sql:WHERE OID=@BuildNOa.sql:WHERE OID INa.sql:WHERE OID=@BuildNOa.sql:WHERE OID INfolder01/b.sql:WHERE OID=@BuildNOfolder01/b.sql:WHERE OID INfolder01/b.sql:WHERE OID=@BuildNOfolder01/b.sql:WHERE OID INgateman@GPC:~/shell/SQL_GSI$ grep -h OID a.sql folder01/b.sqlWHERE OID=@BuildNOWHERE OID INWHERE OID=@BuildNOWHERE OID INWHERE OID=@BuildNOWHERE OID INWHERE OID=@BuildNOWHERE OID IN
gateman@GPC:~/shell$ grep -l -r OID SQL_GSI/SQL_GSI/CreateProcedure.txtSQL_GSI/CreateFunction.sqlSQL_GSI/c.sqlSQL_GSI/a.sqlSQL_GSI/folder01/b.sqlSQL_GSI/CreateProcedure2.txtSQL_GSI/CreateProcedure3.txt
gateman@GPC:~/shell/SQL_GSI$ cat > abc.txtOIDgateman@GPC:~/shell/SQL_GSI$ cat >> abc.txtSalegateman@GPC:~/shell/SQL_GSI$ cat abc.txtOIDSalegateman@GPC:~/shell/SQL_GSI$ grep -n -f abc.txt a.sql1:/****** 对象: 用户定义的函数 dbo.CheckShipSales 脚本日期: 2010-7-23 10:47:27 ******/2:CREATE FUNCTION dbo.CheckShipSales7:DECLARE @Min_SSales AS DATETIME12:/*ShipSales最早修改时间*/13:SELECT @Min_SSales=MIN(UpdateTime)14:FROM ShipSales20:WHERE OID=@BuildNO34:WHERE OID IN40:IF @Min_SSales>=@Max_BVer AND41: @Min_SSales>=@Max_SProgress AND42: @Min_SSales>=@Max_Ship67:DECLARE @Min_SSales AS DATETIME80:SELECT @Min_SSales=MIN(UpdateTime)87:WHERE OID=@BuildNO101:WHERE OID IN137:IF @Min_SSales>=@Max_BVer AND138: @Min_SSales>=@Max_SProgress AND139: @Min_SSales>=@Max_Ship AND140: @Min_SSales>=@Max_MonthMH AND141: @Min_SSales>=@Max_StandardWorkTime AND142: @Min_SSales>=@Max_Calendar AND143: @Min_SSales>=@Max_RainyDays AND144: @Min_SSales>=@Max_DepartmentOfWP AND145: @Min_SSales>=@Max_DeptJobType AND146: @Min_SSales>=@Max_DeptJobTypeOut
- grep 用法介绍
- grep介绍
- grep 介绍
- grep 用法
- grep用法
- grep 用法
- Grep 用法
- grep用法
- grep用法
- grep 用法
- grep用法
- grep 用法
- grep 用法
- grep 用法
- grep 用法
- grep 用法
- grep用法
- grep用法
- 【转】Linux添加/删除用户和用户组
- 【原创】设置头文件路径, gcc -I 选项写法
- 呢篇唔系教程 -- 记录自己第一次Android刷机
- crontab 和 at 的简单区别和用法
- 安装和配置sendmail
- grep 用法介绍
- 学习笔记:文本过滤_____unix 下的通配符
- ubuntu 10.10 配置 tomcat6
- [转]技巧:Vim 的纵向编辑模式
- 转:初学者简易 .vimrc编写指南
- 哈希表原理
- 在Ubuntu/mint里安装VMware tools(虚拟机增强工具)
- Fedora17 开启ssh服务
- (转)Fedora 17 安装完全指南