Now I’ve had this issue one or two times but this is the first time I actually managed to solve it. The scenario is that I had SQL Server 2008 R2 Express install, which is missing the profiler tools. So I thought I’ll just upgrade to standard since we have licenses at my company. That [...]
Category Archives: Databases
Split column in sql (t-sql)
Posted by Tomas Jansson on October 25, 2010
Comments Off
Ok, first of all you should never be in a situation where you need to split columns in a database if you ask me, that is, if you have done your job well. A sql database consists of tables and tables consists of columns so why join columns together and separate the values with ‘;’? [...]