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: )

184 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

510 reads

Blogs

SQL Server on Kubernetes Book Published!

By

I’m super proud to announce that Ben E. Weissman and I have published SQL...

Gathering More Digital Data with Tile Slim

By

After my wallet misadventures, I ordered a Tile Slim to track my wallet. It...

Accessibility is not just about slides

By

Although I don’t write about it much on this website, I am on the...

Read the latest Blogs

Forums

subreport blank lines

By ibax

blank line in subreport

Enabling indexes

By SQLHeap

If I disable an index for a large insert/update/delete, what happens when it's enabled...

Database Triggers

By mballentine

Hi, I need to send out an email every time an alarm level is...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers