You may receive the following errors if you incorrectly alias your column names: Invalid column name No column was specified Check to make sure that your column names are encased in brackets and are not encased by quotes. Incorrect SELECT… Continue Reading
1 2 3 4 5 6 7 8 DECLARE @string varchar(50), @execSql varchar(1000) SET @string = ‘I like kittens’ SET @execSql = ‘INSERT INTO table (column) SELECT ”’ SET @execSql = @execSql + REPLACE(@string, ‘ ‘, ”’ UNION ALL… Continue Reading
Traditional arithmetic would tell you that 5.1 = 5.10. However, arithmetic can’t compare software versions such as 5.1 to 5.10, since 5.10 is the ‘newer’ version. The function below receives two version numbers and returns which of the two is… Continue Reading
The APPLY operator is similar to the JOIN operator, however it specifically allows you to use table functions with parameters to join the results. table1 column —— a1 a2 a3 a4 a5 Using the query below, CROSS APPLY will join… Continue Reading
I recently purchased the Samsung Galaxy SIII from T-Mobile and was unable to clear the icon from the notifications bar. I have my voicemail managed by Google Voice so I first disabled forwarding under Phone > Call Settings > Call… Continue Reading
A common table expression (CTE) is used in this example to create a temporary result set with a sequential number that allows us to do the arithmetic required to calculate percent change.
To select the columns in a specified table in SQL Server, use this code: SELECT c.name FROM sys.columns c, sys.tables t WHERE t.name = ‘table_name’ AND c.object_id = t.object_id
I recently purchased the EPSON WorkForce Pro GT-S50 Document Scanner on Amazon for $329.98. I was also considering the Fujitsu ScanSnap S1500, and settled with the GT-S50 after reading positive reviews. The most common issue I read with the ScanSnap… Continue Reading
Very interesting read on how Instagram solved a problem with having a single unique ID across multiple applications. Sharding & IDs at Instagram
The MSDN article on decimal and numeric data types explains that precision in the decimal data type is the: …total number of decimal digits that can be stored, both to the left and to the right of the decimal point.… Continue Reading