How to find Text in Stored Procedure

-

Search Text in DataBase


SELECT ROUTINE_NAME, ROUTINE_DEFINITION
    FROM INFORMATION_SCHEMA.ROUTINES
    WHERE ROUTINE_DEFINITION LIKE '%Kandy%'
    AND ROUTINE_TYPE='PROCEDURE'

Comments

Post a Comment

Popular posts from this blog

Create and save QR code in asp.net with C#

-
Image
Create and save QR code in asp.net with C# Download Dll from given link https://drive.google.com/drive/folders/0B2VobjpburSGdFBaZzBZSEJic0E?usp=sharing .Aspx Page < form id ="form1" runat ="server">         < asp : TextBox ID ="txtInput" runat ="server"></ asp : TextBox >         < asp : Button ID ="btnGenerate" runat ="server" Text ="Generate" OnClick ="btnGenerate_Click" />         < hr />         < asp : PlaceHolder ID ="plQRCode" runat ="server" />     </ form > .Cs Page using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using QRCoder; using System.IO; using System.Drawing; public partial class CS : System.Web.UI. Page { ...
Read more

Change Text and link in Telerik Radgrid at ITEMDATABOUND event

-
Image
Change  Text and link in Telerik Radgrid at ITEMDATABOUND event Step 1: Design web form .aspx page < div >             < asp : ScriptManager ID ="sm" runat ="server"></ asp : ScriptManager >             < telerik : RadGrid ID ="RadGrid1" runat ="server" CellSpacing ="0" AllowPaging ="true" PageSize ="8" Width ="50%" PagerStyle-AlwaysVisible ="true"                 GridLines ="None" AutoGenerateColumns ="false" OnItemDataBound ="RadGrid1_ItemDataBound"                 OnNeedDataSource ="RadGrid1_NeedDataSource">                 < PagerStyle Mode ="NextPrevAndNumeric"></ PagerStyle > ...
Read more

Export Radgrid in PDF, Word, CSV, Excel format

-
Image
Export Radgrid in PDF, Word, CSV, Excel format Telerik Radgrid provide many predefined function and properties for simplifying working with Telerik control. For exporting Radgrid  in different format we just need to call its function. Step 1: Design web form .aspx page < div >         < div >             < asp : ScriptManager ID ="ScriptManager1" runat ="server">             </ asp : ScriptManager >             < telerik : RadGrid ID ="RadGrid1" runat ="server" CellSpacing ="0" Width ="50%" PagerStyle-AlwaysVisible ="true"                 ShowFooter ="true" GridLines ="None" AutoGenerateColumns ="false" OnNeedDataSource ="RadGrid1_NeedDataSource"> ...
Read more