Replace Enter key from string in Sql

-

Replace Enter key from string  in Sql




declare @C nvarchar(max)
set @C='kandy
deol'
select @C as WithEnterKey
select REPLACE(REPLACE(@C, CHAR(13), ''), CHAR(10), '') as WithOutEnterKey



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 of RadGrid Header Dynamically

-
Image
Change text of RadGrid Header Dynamically 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" OnPreRender ="RadGrid1_PreRender"  OnItemDataBound="RadGrid1_ItemDataBound1"                 OnNeedDataSource ="RadGrid1_NeedDataSource">                 < PagerStyle Mode ="NextPrevAndNumeric"></ PagerStyle...
Read more

Telerik Radwindow Open on Button Click

-
Image
Telerik Radwindow Open on Button Click Step 1: Design web form .aspx page < div >             < asp : ScriptManager ID ="ss" runat ="server"></ asp : ScriptManager >             < telerik : RadWindow ID ="modalPopup" runat ="server" Width ="250px" Height ="100px"   VisibleTitlebar ="false"   Modal ="true" VisibleStatusbar ="false"   EnableShadow ="true"   >                 < ContentTemplate >                                        < p style =" text-align : center ; ">             ...
Read more