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

Add Multiple Rows in Telerik Radgrid on Button click and Save its Data

-
Image
Add Multiple Rows in Telerik Radgrid on Button click and Save its Data Step 1: Design web form .aspx page   < div >         < asp : ScriptManager ID ="SM" runat ="server">         </ asp : ScriptManager >         < telerik : RadGrid ID ="RadGrid1" runat ="server" AutoGenerateColumns ="false" Width ="50%"             OnNeedDataSource ="RadGrid1_NeedDataSource" OnItemDataBound ="RadGrid1_ItemDataBound"             OnItemCommand ="RadGrid1_ItemCommand">             < MasterTableView DataKeyNames ="ID" CommandItemDisplay ="Top">                 < Columns >     ...
Read more