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)
278 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
429 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
579 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
194 reads
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Comments posted to this topic are about the item Creating a JSON Document I
Comments posted to this topic are about the item Who is Irresponsible?
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers