Advanced Querying

External Article

SQLChess - A tutorial on thinking in sets

  • Article

Chess makes a fantastic game for programming examples. You will find hundreds of examples on the internet. Some dedicated to OO patterns, others to algorithms and so forth. Unfortunately, most of these examples do not use a database or if they do, treat the database as nothing more than a storage repository. In this series of articles we will use SQL Server and T-SQL to implement the game of chess with an emphasis on thinking in sets.

2007-05-21

5,228 reads

External Article

Returning a week number for any given date and starting fiscal month

  • Article

Sql Server comes with a host of built in functions such as ISNULL, CONVERT and CAST. Now if that wasn't enough rope to hang ourselves with, as of Sql Server 2000 we gained the ability to create our own user defined functions. In this article I will be looking at the three main date functions DATEADD, DATEPART and DATEDIFF (there is a fourth called DATENAME but I want to get to the end of this article before you fall asleep so I decided to leave it for another date and time! And no it doesn't foretell the name of your future blind date so it's not as interesting as it sounds anyway) Then I will be combining all three in a user defined function of our own by which time our necks will be well and truly stretched

2007-05-15

2,831 reads

SQLServerCentral Article

Storing IPs in SQL Server

  • Article

An IP address is something we all recognize and is a piece of data that is quite prevalent in many systems. However it is a piece of
data tha presents some challenges in its storage and retrieval. SQL Server guru David Poole presents us with a look at how you can
work with this strange formatting.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.75 (8)

You rated this post out of 5. Change rating

2008-02-19 (first published: )

17,077 reads

SQLServerCentral Article

NULL Versus NULL?

  • Article

Dealing with NULL data is something that often confuses new SQL Server developers, but even experienced DBAs might not understand all the intricacies of NULL operations. In a follow up to his highly acclaimed Four Rules of Null article, Michael Coles brings us a few new
tricks with NULLs.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.74 (81)

You rated this post out of 5. Change rating

2008-01-25 (first published: )

39,053 reads

Blogs

Using T-SQL Snapshot Backup - Are Snapshots Backups?

By

Introduction Traditional SQL Server backups can struggle with large databases, resulting in longer backup...

Developer Q&A: Dika Fei of Jelly Pixel Studio

By

"Let me know where you get your magic pixie dust from!"

A New Word: Flashover

By

flashover – n. the moment a conversation becomes alive and real, when a spark...

Read the latest Blogs

Forums

GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

It's Time to Play

By Ryan Booz

Comments posted to this topic are about the item It's Time to Play

Call Dates Effective Range

By Yash34

Hi Everyone, I have the data in the below form : Desired output: Here...

Visit the forum

Question of the Day

Synapse Analytics History III

What was the originally name of the appliance that eventually became Azure Synapse Analyics?

See possible answers