Match Date Only

Here is a simple function to compare datepart of datetime fields , (no need to say ignores hour t,min,sec ... ) isDateMatch(@date1,@date2 ) retruns 1 if the datepart matches else returns 0regardsjohn

2 (1)

2007-03-21 (first published: )

181 reads

Convert Numeric Figures into Words

Hi guys    What about a function that converts a number figure into words.This sample script is to demonstrate the procedural capabilities of SQL Server . Samples  select fig2words(10) will give --Ten-- ,select fig2words(103) will give --one hundred and three --    The author uses much under utilized capability of SQL Server the recursive function calls to […]

2003-11-11

485 reads

Blogs

What the ???? T-SQL Tuesday #120

By

Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and...

First Time Speaking at PASS Summit

By

This week, I filmed my experience as a first time speaker at PASS Summit...

Azure SQL Best Practices?

By

A way to enforce good practice and standards is by Azure Policy. As stated...

Read the latest Blogs

Forums

Limiting the Data Frame

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Limiting the Data Frame

Micro Credentials

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Micro Credentials

CheckDB on VLDB, Geography data type

By el_Guapo

I've narrowed down a DBCC CheckDB issue to a set of tables with Geography...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers