Most word count functions/procedures are based on some form of looping methods. If the table is large or there is a need to count the words in a number of columns, this can become quite an exercise. This function, based on a mathematical model, will work much faster and more efficient in counting the words […]
2005-12-28 (first published: 2005-12-12)
279 reads
A lot of table pivoting scripts use cursors to reach the desired results, but SQL scripting was developed to be utilized in a data set environment rather than sequential step-thru scripting.Normally, there are 3 types of Table Pivoting - 1) column explicit 2) column implicit and 3)single column. COLUMN EXPLICIT will place the row value […]
2003-05-29
431 reads
The script will do the following:- build a ten digit phone number regardless of input column size.- Ignores extensions- Ignores leading 1, as in 1(800)...- Ignores most special characters or spaces- converts literals to digitsIt can be easily convert to a UDFEnjoy.C. Z. Ovits
2002-10-28
580 reads
Using the sp_help to get a table structure is very cumbersome. First, in order to print it you have to use"Results in Text" not "Results in Grid". Second, the results are very wide screen-wise and very hard to read or print. Third, you do not get the size or number rows with the same request.This […]
2002-10-28
198 reads
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
Comments posted to this topic are about the item The Distance Metric
Comments posted to this topic are about the item The New Wave of Security...
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers