How to remove NewLine characters from the data in SQL Server

select REPLACE(REPLACE(REPLACE(MyField, CHAR(10), ''), CHAR(13), ''), CHAR(9), '')  from table

Comments

Post a Comment

Popular posts from this blog

How to Fix Error- Sys.WebForms.PageRequestManagerTimeoutException - The server request timed out

To solve this problem we can increase the timeout. You can change the timeout time by adding a new property to the script manager control. This property is called AsyncPostBackTimeOut and it can help us to define the number of seconds before the request will throw a request timeout exception*. For example if you want that the timeout will take maximum 10 minutes your code should be look like this: < asp : ScriptManager ID ="ScriptManager1" runat ="server" AsyncPostBackTimeOut ="600" > </ asp : ScriptManager >       * The default value of the AsyncPostBackTimeOut property is 90 seconds.
Read more

Creating groups and summaries in Grid View

GridView has a lot of improvements over the DataGrid but it still lacks some very important features. A recurring requirement not available in the GridView is to create groups and summaries. To create summaries we can easily code the RowDataBound event. Grouping is a more complex task, and involves more coding and debugging. But when we need to combine these two features the things really start to get messy. With this in mind I have implemented the GridViewHelper, as the name suggests, a helper class to aid the creation of groups and summaries. [ Online sample ] [ Download source code ] Using the GridViewHelper Below we will see some GridViewHelper samples. First we show the grid to which the groups and summaries will be created. The sample data comes from Northwind database, with a few modifications: ShipRegion ShipName OrderId ProductName Quantity UnitPrice ItemTotal NM Old Worl...
Read more

Resize image the time of uploading using asp.net

<form id="form1" runat="server"> <asp:FileUpload ID="fileUpload" runat="server" /> <br /><br /> < asp : Button   ID ="uploadButton"   runat ="server"   Text ="Upload!"   OnClick ="UploadFile"   /> <br /><br /> < asp : Label   ID ="label"   runat ="server"></ asp : Label >   < br   />< br   /> <asp:Image ID="Image1" ImageUrl="" runat="server" Visible="false" /> </form>   protected void UploadFile(Object s, EventArgs e)      {          // First we check to see if the user has selected a file           if (fileUpload.HasFile)           {                // Find the fileUpload control               ...
Read more