Browse by Tags

Enhanced ISNUMERIC() Function

Published 15 July 7 4:14 AM | SSQA.net

It seems often users want to check whether the data has only numbers in a varchar type column. The commonly suggested one is to make use of SQL Server's ISNUMERIC() function. But the problem in using that function is that it will treat some alphabets...

Filed under: sql server, performance, function, tsql, isnumeric

Using table-valued functions (TVF) in SQL Server

Published 29 June 7 3:13 AM | SSQA.net

I was looking for more information on Table-Valued Functions (TVF) in SQL Server in attempting to perform sophisticated text analysis using the built-in string functions using .NET. To the subject using regular expressions are not new to SQL. These regular...

Filed under: sql server, performance, memory, function, tvf, feature, table-valued, .NET