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