SQL

External Article

The Basics of Good T-SQL Coding Style – Part 3: Querying and Manipulating Data

  • Article

SQL was designed to be a third-generation language, expressed in syntax close to real language, because it was designed to be easy for untrained people to use. Even so, there are ways of expressing SQL Queries and data manipulation in ways that make it easier for the database engine to turn into efficient action. and easier for your colleagues to understand. Robert Sheldon homes in on data querying and manipulation and makes suggestions for team standards in SQL Coding.

2017-08-25

5,735 reads

External Article

Doing Fuzzy Searches in SQL Server

  • Article

A series of arguments with developers who insist that fuzzy searches or spell-checking be done within the application rather then a relational database inspired Phil Factor to show how it is done. When the database must find relevant material from search terms entered by users, the database must learn to expect, and deal with, both expected and unexpected.

2017-04-27

7,260 reads

Blogs

Goal Progress for Nov 2022

By

I set goals at the beginning of the year, and I’m tracking my progress...

PGSQL PHRIDAY #3: What is the PostgreSQL Community To You?

By

Very excited to take part in my third #PGSQLPhriday blogging event, even more so...

Daily Coping 2 Dec 2022

By

Today’s coping tip is to enjoy new music today: play, sing, dance, or listen....

Read the latest Blogs

Forums

SSRS REPORT

By RDOT

Hi Guys have project the require to create checkbox in one off my ssrs...

Selecting temp tables & CTEs using PowerBI

By JeremyU

I have a pretty difficult assignment. This is the structure that I need to...

Making the World Better

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Making the World Better

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers