Owning the Spelling Suggestion Feature
To create your own spelling suggestion feature, you need a look-up with correct spellings and misspellings. I walk you through it.
2008-07-21
4,677 reads
To create your own spelling suggestion feature, you need a look-up with correct spellings and misspellings. I walk you through it.
2008-07-21
4,677 reads
While working on a project recently I was asked to develop a mechanism that would provide the dates for state and federal holidays in a given year. Since this project deals with all states and territories of the United States, the list had to be comprehensive and the client asked that this list be in the form of a SQL query calculated on-the-fly, rather than a static list.
2008-07-21
5,482 reads
2008-09-19 (first published: 2008-07-20)
1,463 reads
2008-07-20
1,399 reads
2008-09-08 (first published: 2008-07-20)
1,254 reads
Script to return Rows count from table using sp_ExecuteSQL
2008-09-26 (first published: 2008-07-20)
1,513 reads
2008-10-10 (first published: 2008-07-20)
1,852 reads
All of us have problems with Duplicate rows, here is a simple and efficient way of removing duplicate rows
2008-10-03 (first published: 2008-07-18)
1,652 reads
Histograms help people analyze large amounts of data, whether you display them as tables or as charts. This article shows you how to do both.
2008-07-16
3,216 reads
One thing you may need to do is dynamically return a set amount of rows based on user input. This could be for a search function, reports, dropdown lists or whatever. Instead of hard coding a set value you would like to pass in a variable that will then determine the number of rows to return. How can this be done with T-SQL?
2008-07-16
4,539 reads
Let's be honest – SQL can be a bit of a beast. At first...
By alevyinroc
Sometimes, work tasks and questions that come up in the SQL Server Community Slack...
By Steve Jones
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family,...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers