Pavel Nikolov's Blog http://pavelnikolov.net Dreamer. Cyclist. Hiker. Blogger. Web Developer. Wed, 22 Feb 2012 18:51:35 +0000 en hourly 1 http://wordpress.org/?v=3.3.1 Replace a newline in T-SQL http://pavelnikolov.net/2012/02/replace-a-newline-in-t-sql/ http://pavelnikolov.net/2012/02/replace-a-newline-in-t-sql/#comments Wed, 22 Feb 2012 18:48:17 +0000 Pavel http://pavelnikolov.net/?p=30 Today I had to import data for a client into MSSQL. One of the tasks required replacing all the newline symbols in a column with semicolon (;)

Here is a solution:

REPLACE(@someString, char(13) + char(10), ';')

this code replaces all newline symbols in @someString with (;).

]]> http://pavelnikolov.net/2012/02/replace-a-newline-in-t-sql/feed/ 0 Fancy jQuery scrollbar http://pavelnikolov.net/2012/01/fancy-jquery-scrollbar/ http://pavelnikolov.net/2012/01/fancy-jquery-scrollbar/#comments Sun, 08 Jan 2012 20:31:38 +0000 Pavel http://pavelnikolov.net/?p=27 Today I was wondering how to implement a fancy scrollbar like the ones in Google Reader or Facebook. I found exactly what I was looking for here: http://jsfiddle.net/PVZB8/139/

]]> http://pavelnikolov.net/2012/01/fancy-jquery-scrollbar/feed/ 0 Hello, blogosphere! http://pavelnikolov.net/2010/03/hello-blogosphere/ http://pavelnikolov.net/2010/03/hello-blogosphere/#comments Sun, 21 Mar 2010 10:35:23 +0000 Pavel http://pavelnikolov.net/blog/?p=1 Welcome to my blog. I’m happy you are reading my very first blog post. I had a “Buy a domain and setup a blog” task in my TODO list for a long time and finally I decided to really start blogging.

Expect more posts soon.

]]> http://pavelnikolov.net/2010/03/hello-blogosphere/feed/ 1