{"id":481,"date":"2013-05-25T19:03:35","date_gmt":"2013-05-25T10:03:35","guid":{"rendered":"https:\/\/potal.poweredge.co.jp\/blog\/?p=481"},"modified":"2013-05-25T19:03:35","modified_gmt":"2013-05-25T10:03:35","slug":"sqlserver-%e3%82%b9%e3%83%88%e3%82%a2%e3%83%89%e3%83%97%e3%83%ad%e3%82%b7%e3%83%bc%e3%82%b8%e3%83%a3%e3%82%92grep%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/po-tal.poweredge.co.jp\/blog\/?p=481","title":{"rendered":"SQLServer \u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092Grep\u3059\u308b"},"content":{"rendered":"<p>\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u5185\u3092Grep\u3057\u305f\u3044\u306a\u3041\u3068\u601d\u3063\u305f\u3089\u3001\u3042\u3063\u305f\u3002<br \/>\n\u30cd\u30c3\u30c8\u304b\u3089\u306e\u62fe\u3044\u3082\u306e\u3002<\/p>\n<pre>\n--\u30b9\u30ab\u30e9\u95a2\u6570\n--@SpName : \u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306e\u4e2d\u5473\u3092\u53d6\u5f97\u3059\u308b\u305f\u3081\u306e\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u540d\nCreate Function fncFindSp (\n@SPName Varchar(255)\n)\nReturns Varchar(8000) As\nBegin\n\nDeclare @SpBody Varchar(8000)\nDeclare @RetText Varchar(8000)\n\nSet @SpBody = ''\nSet @RetText = ''\n\nBegin\nDeclare Cur1 Cursor For\n\nSelect syscomments.text\nFrom sysobjects\nInner Join syscomments\nOn sysobjects.id = syscomments.id\nWhere sysobjects.xtype = 'P'\nAnd sysobjects.status >= 0\nAnd sysobjects.name = @SPName\nOrder By\nsyscomments.colid\n\nOpen Cur1\nFetch Next From Cur1 Into @SpBody\n\nWhile (@@Fetch_Status <> -1)\nbegin\nIf @SpBody <> ''\nBegin\nIf RTrim(@RetText) = ''\nBegin\nSet @RetText = @SpBody\nEnd\nElse\nBegin\nSet @RetText = @RetText + @SpBody\nEnd\nEnd\nFetch Next From Cur1 Into @SpBody\nEnd\nClose Cur1\nEnd\nReturn @RetText\nEnd\ngo\n\n--Grep\u7528\u30b9\u30c8\u30a2\u30c9\n--@seachWord : \u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u5185\u3092\u691c\u7d22\u3059\u308b\u6587\u5b57\u5217\nCreate Procedure spGrep\n@seachWord Varchar(255)\nAs\nBEGIN\nselect X.*\nfrom\n(\nSelect\nsysobjects.[name] As ProcName ,\ndbo.fncFindSp(sysobjects.[name]) as ProcBody\nFrom sysobjects\n) X\nwhere X.ProcBody like  '%'+@seachWord + '%'\nEND\n<\/pre>\n<p>\u5b9f\u884c<\/p>\n<pre>\nEXEC dbo.spGrep '\u691c\u7d22\u6587\u5b57\u5217'\ngo\n<\/pre>\n<p>\u53c2\u8003\u21d2<a href=\"http:\/\/nekojarasikou.seesaa.net\/article\/132917515.html\">\u3053\u3053<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u5185\u3092Grep\u3057\u305f\u3044\u306a\u3041\u3068\u601d\u3063\u305f\u3089\u3001\u3042\u3063\u305f\u3002 \u30cd\u30c3\u30c8\u304b\u3089\u306e\u62fe\u3044\u3082\u306e\u3002 &#8211;\u30b9\u30ab\u30e9\u95a2\u6570 &#8211;@SpName : \u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306e\u4e2d\u5473\u3092\u53d6\u5f97\u3059\u308b\u305f\u3081\u306e\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u540d Create Function fncFi [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[19,34],"_links":{"self":[{"href":"https:\/\/po-tal.poweredge.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/481"}],"collection":[{"href":"https:\/\/po-tal.poweredge.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/po-tal.poweredge.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/po-tal.poweredge.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/po-tal.poweredge.co.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=481"}],"version-history":[{"count":0,"href":"https:\/\/po-tal.poweredge.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/481\/revisions"}],"wp:attachment":[{"href":"https:\/\/po-tal.poweredge.co.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=481"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/po-tal.poweredge.co.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=481"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/po-tal.poweredge.co.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}