SQL Azure and support for CTE syntax?
- by Coolcoder
Does anyone know if SQL Azure supports CTE syntax? Specifically; WITH, OVER, ROW_NUMBER(), PARTITION BY
Search Results
Search found 3 results on 1 pages for 'coolcoder'.
Page 1/1 | 1
-
-
Regular Expression for accepting numbers 0 to 9999
- by Coolcoder
I want a regular expression for only accepting 0-9999 No spaces, no letters. However, "blank"(empty) is allowed.Read the article
-
FORMSOF Thesaurus in SQL Server
- by Coolcoder
Has anyone done any performance measures with this in terms of speed where there is a high number of substitutes for any given word. For instance, I want to use this to store common misspellings; expecting to have 4-10 variations of a word. <expansion> <sub>administration</sub> <sub>administraton</sub> <sub>aministraton</sub> </expansion> When you run a fulltext search, how does performance degrade with that number of variations? for instance, I assume it has to do a separate fulltext search performing an OR? Also, having say 20/30K entries in the Thesaurus xml file - does this impact performance?Read the article
