Concatenate rows in a SQL table into a string

Concatenate rows in a SQL table into a string

Occasionally you may need to join the results of a query into a single string. You need to go from this: To this: At first this may seem challenging, but it’s actually relatively simple. Example script Transact-SQL CREATE TABLE #TestData (Data int) INSERT INTO...
Use randomized data to increase a test data set

Use randomized data to increase a test data set

Recently I was tasked with evaluating several possible solutions for a SQL Server search engine to search a database of students. For a proof of concept, I had a small snapshot of approximately 200,000 students. I needed to expand this data to simulate a much larger...
Windows 8.1 Hibernate Option – where is it?

Windows 8.1 Hibernate Option – where is it?

Yesterday, I got my new laptop running Windows 8.1 Enterprise. It’s a great improvement over my 4 year old first gen Core i5 system, and I’m sure it will be a wonderful system. My problem came at the end of the day when it was time to power down for the...
Free WordPress Themes, Free Android Games