Geeks With Blogs

Victor Cassel A Microsoft data programmer guy in Stockholm
Here is a surprisingly effective way of generating integer sequences, and date ranges on sql server. This source code is also available at githubFirst we need a function that generates the numbers from 0 to 99.ALTER FUNCTION [dbo].[Nums100] ( ) RETURNS TABLE AS RETURN ( SELECT 0 rownum union select 1 union select 2 union select 3 union select 4 union ......

In this post I will discuss some search skills and tricks that I have acquired during my years of developing in .Net against Microsoft SQL Server: Dynamic queries Regex-searching Free-text searching At my previous position, we needed to implement free-text search for more than 600,000 bug documents, and were happy to find out that SQL Server had full-text ......

Copyright © Victor Cassel | Powered by: GeeksWithBlogs.net