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

GROUP BY, CUBE, ROLLUP and SQL SERVER 2005

Image
  I learn about CUBE and ROLLUP function today and I found it really usefull for generating reports. Let me give you one example where we can use ROLLUP and CUBE. Lets say you are developing the E-Commerce application and administrator wants the report which shows products purchased by all user group by product and buyer. You will say that’s really easy and can write the query as shown below, 1: SELECT CustomerName,CustomerName,SUM(Quantity*PricePerItem) 2: FROM Orders GROUP BY CustomerName,CustomerName Fig – (1) Group By clause.      Which will returns the result as shown below, Fig – (2) Result of GROUP BY clause     However what if you want result as display below, Fig – (3) Desire result        Here ROLLUP and CUBE comes into the picture and help us. The above result is generated using ROLLUP.  ROLLUP adds new row for each column used in GROUP BY clause. First have a look ...
Read more

Generate Random Number in SQL Server between two numbers

Image
  Create the variables for the random number generation DECLARE @Random INT ; DECLARE @ Upper INT ; DECLARE @ Lower INT   ---- This will create a random number between 1 and 999 SET @ Lower = 1 ---- The lowest random number SET @ Upper = 999 ---- The highest random number SELECT @Random = ROUND(((@ Upper - @ Lower -1) * RAND() + @ Lower ), 0) SELECT @Random ======Output
Read more