Radbryt på SQL Server

Jag behövde formattera några databastexter som (x)html och körde följande för att få  paragrafer runt textstyckena. På Stack Overflow lärde jag mig att CHAR(13) är tecknet för radbryt.

UPDATE Post SET Body='<p>' + REPLACE(Body,CHAR(13),'</p><p>') + '</p>'

Vissa rekommenderar  att formattera först när man visar upp texten för användaren, men jag brukar vilja ha även htmltaggarna i databasen.

Comments

Förihelvete, data är data, presentation är något helt annat. Formatera inte datat i databasen utan vid presentationen. Tänk längre än webb.

Hej Angry Coder,

Tack för din synpunkt. Hur gör vi om vi vill låta användaren göra egen layout i en editor? Är nog smidigast att spara i databasen tror jag. Wordspress och de andra gör väl likadant.

Men har du nån idé hur jag skulle kunna göra om radbryt "on the fly" till paragraf-taggar? Vill inte ha <br/>

The particulars and exact recommendation are insurance specifically what I was wanting. I’ve book marked and will definitely be returning. Thanks for the information in this blog.

This will be the most big resourcefulness that you are rendering and you turn over it away for free. I savour seeing websites that be conscious of the value of supplying a prime resource for free. I truly enjoyed reading your Wiley Post. Thanks!

I realise and could not do it without having your tolerance . I change accumulation scarred this article to sound and zynga calculate intended for remark. Anyway realize it either way!

subject matter stylish. nonetheless, you command get bought an nervousness over that you wish be delivering the following. unwell unquestionably come further formerly again since exactly the same nearly very often inside case you shield this Garrett Ace 350

just well thought out and really fantastic to see someone who knows how to put these thoughts down so well. Great job on this.

you’ve nailed it. You write very well which is amazing. I really impressed by your post. I like this shop. Im continually obtaining new issues that Manhattan Hotel Jakarta I want, or need, or better but, factors I shouldnt invest in but cant resist shopping for! And at terrific costs too! Thank you so significantly for keeping such a excellent shop! Business to business telesales

In fact your creative writing skills have inspired me to get my own blog going now. Actually blogging is spreading wings and growing quickly. Your write up is a great example.

The information and the detail were just perfect. I think that your perspective is deep, its just well thought out and really fantastic to see someone who knows how to put these thoughts down so well. Great job on this.

The information and the detail were just perfect. I think that your perspective is deep, its just well thought out and really fantastic to see someone who knows how to put these thoughts down so well. Great job on this.

I loved as much as you will receive carried out right here. The sketch is attractive, your authored subject matter stylish. nonetheless, you command get bought an nervousness over that you wish be delivering the following. unwell

I loved as much as you will receive carried out right here. The sketch is attractive, your authored subject matter stylish. nonetheless, you command get bought an nervousness over that you

With lots of wonderful options of North Experience Jakcets Outlet, you will be ready for all seasons and all sorts of climate conditions.Obtainable in only about every single shade from pink to orange, sky blue to lime green, this slim coat undoubtedly delivers a bit a thing for everyone.Hat, the particular size can influence the actual degree involving in shape.Karen Millen Dresses Neck marriage ceremony this year set off the rate of growth in retro type with the appeal of asymmetric solitary glenohumeral joint wedding ceremony attracts everybody's consideration, once again going back to fashion trends.Within the cold of winter,it truly is essential to have the protection from North Encounter Jackets.They even touched the actual He Damon the particular Hollywood celebrity.

Intresting article. Thanks you very much for this wonderful share.

Most of the time I don’t make comments on blogs, but I want to mention that this post really forced me to do so. It's just great site.

I loved as much as you will receive carried out right here. The sketch is attractive, your authored subject matter stylish. nonetheless, you command get bought an nervousness over that you

Good post. This is a very nice blog that i will definitively come back to more times this year. Thanks for informative post.

Good post. This is a very nice blog that i will definitively come back to more times this year. Thanks for informative post.

Good post. This is a very nice blog that i will definitively come back to more times this year. Thanks for informative pos. bioidentical hormone replacement

Good post. This is a very nice blog that i will definitively come back to more times this year. Thanks for informative post.bioidentical hormone replacement

this as blogposts I staleness say i launch this fact one to mostly be top notch. I soul a weblog also and require to repost a few shears of your articles on my own diary site. Should it be alright eternal I own testimonial

The CDP Pro database is translated to several languages. Autocom uses Original Data from vehicle manufacturers to guarantee the best quality and functionality. AK-47

A fantastic webpage always comes-up with new and exciting information and while analyzing I have think this webpage is really have all those fantastic that are qualified a webpage to be a fantastic one.

post I shouldnt invest in but cant resist shopping for! And at terrific costs too! Thank Like it! I like it a lot. the angles.

! I am satisfied to locate numerous useful information here in the post. Thank you for sharing....

blogposts I staleness say i launch this fact one to mostly be top notch. I soul a weblog also and require to repost a few shears of your articles on my own diary site. Should it be alright if I use this as eternal I own testimonial your web blog or create a inward unification to your article

I would like to thank you for the efforts you have put in writing this blog. I am hoping the same high-grade blog post from you in the future as well. In fact your creative writing skills have inspired me to get my own

Thank you for sharing....

Good – I should definitely say I'm impressed with your blog. I had no trouble navigating through all the tabs as well as related info. The site ended up being truly simple to access. Excellent job..

Excellent article written by the author to express views and explanations related to the subject. Thanks for your great efforts.goto goodwork

The photos given here is so informative and you have done an excellent job in introducing it for visitors like me. Sincere thanks for such a good idea and you should keep on including the nice postings like these. Thanks again.visit this site

Once your skills and experiences are identified you can then move on to identify the opportunities available to you. jobs and career guide

The natural eye, I think is a talent or a gift an individual is born with. Just like an artist who paints great beautiful portaits. photo graphy jobs.eu

"Inflation is an important economic tool for the Chancellor. In it he has an ally that is systematically reducing the real value of the UK's debt, and, at the same time, by manipulating the measures used to report inflation, he is able to reduce Government spending that is index-linked to it. The fact that inflation is also eroding the value of Britain's savings seems to be of no concern to him at all." my budgeting work sheet

This is actually my first full post about the wedding, or any happenings around it, on Fashables, but I thought it might be fun to hear a guys view of the process. all fashion magazine

These days, the most popular choice plan is a pay as you go plan (or pay as you go plan). Many firms are offering these ideas, and you can opt for any phone you want when you are on these plans, as long as the phone is unlocked. unlock cell phone guide

Gick det bra med formatteringen? har nämligen samma problem men får inte det o funka...

options binaires

landscan.co.uk we can attest that, for many reasons, the voice over field continues to grow, and the need for voice over talent is booming.

The word essay is labeled as a short piece of writing on a specific topic that is done by mostly students as part of a course of study.Pay for essay it is also used to style an attempt or try or a trial design of a stamp that is yet to be accepted.

Thank you for taking the time to publish this information very useful!I’m still waiting for some interesting thoughts from your side in your next post thanks. www.casinogoerlitz.com

great! this is the easiest way to learn more regarding SQL Server. Thanks author.

I think that the team boxers are using advice of many energy advices. They are professionals in them job. http://futurition.eu/

very helpful and useful ideas and tips about home decorate and design, that how to decorate our home. for example rooms, bathroom and kitchen color combination, furniture design, fabrics design and color. http://www.sleepy-hollow-design.com/"> http://www.sleepy-hollow-design.com/ http://www.aquasoleilspa.com/"> http://www.aquasoleilspa.com/

I think that the team boxers are using advice of many energy advices. They are professionals in them job

I loved as much as you will receive carried out right here. The sketch is attractive, your authored subject matter stylish. nonetheless, you command get bought an nervousness over that you

http://sportstersforever.com/

Now You Booked Hotel Rooms In Every Place, Home, Office, And Other's. Book Top And Luxury Hotel In The France, Australian, Europe and Dubai. And Get Traveling Tips And Ideas For Our. http://www.hotel-austral.com/"> http://www.hotel-austral.com/

If You Want Purchase A Used Car. Then You Vsit This Because In This Very Useful Ideas And Tips For Car. And Tips To Reduce Car Insurance Quotes. And many More For Used Cars. http://clayton-usedcars.com/"> http://clayton-usedcars.com/

I think that the team boxers are using advice of many energy advices. They are professionals in them job

OZGECELIKEV.COM HANDELONTHELAWTV.COM

Fashion News And Fashion Accessories, etc Pants, Shirts, Trousers, Shoes, Belts, Sunglasses, Bags, And Many More For Man, Women And Kids. Every Thing Fashion Related items for every one. http://thebocaratonalist.com/"> http://thebocaratonalist.com/

very Hopeful and nice ideas for green Houses. And forming relative items and accessories. http://sunwaterseed.com/"> http://sunwaterseed.com/

Many ideas and tips for earn money in home. How to earn Online money on internet. http://specialriskonline.com/"> http://specialriskonline.com/

The natural eye, I think is a talent or a gift an individual is born with

EASYCLICKADS.COM TRAVELCOSTHELPER.COM TORONTONIAGARAFALLSBUS.COM

Most Wanted Recipes For Anytime And Every One. Baby Food, Chicken Recipes, Pasta Recipes, Healthy Food, Ice Cream And Others. Know For Kitchen Tools And Cooking Techniques. www.mostwantedrecipes.com"> www.mostwantedrecipes.com

Information for Study Visa, Business Trip, Holiday Trip And Other Visa Information. And Know Prefect Hotel And Places. www.northcyprustrip.com"> www.northcyprustrip.com

I think that the team boxers are using advice of many energy advices. They are professionals in them job.

Best Regards sleepy-hollow-design.com clayton-usedcars.com

I think that the team boxers are using advice of many energy advices. They are professionals in them job.

Best Regards fullservice-bigsavings.com aquasoleilspa.com hotel-austral.com

good post.and thank you for sharing this new ideas. http://www.onlinepromotionuae.ae

amazing information and thanks for sharing a new ideas...... www.andamandiscover.com"> www.andamandiscover.comlink text

nice posting...... http://onlinepromotionhouse.com

Printer has a great importance in professional fronts. What will happen if your HP printer stops working while printing some of your important documents? Well answer for it will be available at HP Printer Help Desk Number UK . Just call and correct errors in your printer by your own.

Nice Content.. Thank you for sharing.After installing Avira we stop worrying about the malwares of cyberspace. But when we get to face issues with this antivirus don’t hesitate and call us at 0800-098-8371 Avira Customer Care Number UK. The experts here will provide you best resolution for all your issues. More Help you touch with Avira phone Number UK

Great blog! I really love how it is easy on my eyes and the information are well written. We Provide for Hotmail user technical support Number UK more help touch here: Hotmail Support Number UK Hotmail Help Number UK Hotmail Contact Number UK

this is outstanding and great post! i really like it. thank you so much

Avast Support UK

yes man, its a very useful article. i tried it on my sites. its work. thank you so much hp printer support

Yes man, its a very useful article. i tried it on my sites. its work. thank you so much. Epson Printer Customer Service

Thanks for this awesome web page, i like it. Toshiba contact number

Today I learned a lot from your website. thank you. Norton antivirus helpline number

Hii, Thanks for the sharing nice posting with us. i’m really impressed. epson support

Thanks for sharing nice information with us. Lenovo Support Number UK Lenovo Help Number UK Lenovo Helpline Number UK

This is outstanding and great post! i really like it. thank you so much. dell tech support

yes man, its a very useful article. i tried it on my sites. its work. thank you so much epson helpline

The system works slowly or system just unable to remove to previous antivirus after its installation is the issue that you can resolve by dialing 0800-098-8371 UK. The expert technicians are ready to sort out the issues. More help you can touch with McAfee Help Number UK McAfee Phone Number UK McAfee Support Number UK

this is outstanding and great post! i really like it. thank you so much.

Toshiba Tech Support

Hi.. This series is awsum. Such kinds of series are always awsum. You do everything what can make your site more interesting. You know, I always wait for your new updates. I would thank you for entertaining us.

Lenovo support number

I feel myself very lucky for being on this site. Each and every series what you take for us are awsum. you are very humble to users. You update everything here for your readers. Thank you.

Norton antivirus helpline number

Hi.. This series is awsum. Such kinds of series are always awsum. You do everything what can make your site more interesting. You know, I always wait for your new updates. I would thank you for entertaining us.

Toshiba technical support number

Today I learned a lot from your website. thank you. norton support contact number Norton Support Contact Number UK

yes man, its a very useful article. i tried it on my sites. its work. thank you so much.

Sky Broadband Support

Very Very nice post. its a very useful and outstanding article. Thanks for that.

This is really very nice blog and so informative. Thanks a lot for sharing this article.

Content is very useful and topic is also very good. I like it.

Really fantastic post. Its very interesting post. Thank you for sharing. Solve issues for Brother printer. Brother Printer Support Number UK Brother Printer Help Number UK

very very nice article, thanks for the sharing with us

Hey...... such a useful info.

Bullguard support number UK

Bullguard helpline number UK

This is outstanding and great post! i really like it. thank you so much.

windows customer service

microsoft helpline

Please fill out all the fields.

*
*