Featured Post

Asus 1000h eeePC – My New Favorite Tool

I spend a great of time on computer.   As a Internet software developer at my day job, and a consultant and blogger  after hours, most of my waking hours are in front of a screen.  When I built our new house, I insured it had a office on the first floor, close to the general living spaces, within...

Read More

Having Trouble Scripting SQL Tables Containing nvarchar(max) fields

Posted by Joe King | Posted in MS SQL | Posted on 22-08-2010

0

Have you trying to script tables in your SQL2005 or 2008 database and you receive this error?

Column projectDescription in object [TABLENAME] contains type NVarCharMax, which is not supported in the target server version, SQL Server 2000. (Microsoft.SqlServer.Smo)

This error is caused by an incorrect scripting option in Microsoft SQL Server Management Studio being set to a version prior to 2005.

Continue reading...

Improving Excel’s CONCATENATE function

Posted by Joe King | Posted in MS SQL, Random Geekery | Posted on 23-09-2009

0

Came across this “where-have-you-been-all-my-life” improvement for Microsoft Excel’s lackluster CONCATENATE function in the latest Network World magazine.

It is a VBA function that can concatenate a range of fields and include a “separation character” between each value.

I often use Excel to build bulk SQL insert statements. This will prove to be very useful.

http://www.cpearson.com/excel/stringconcatenation.aspx

via: Network World

Continue reading...