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

183 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

505 reads

Blogs

Daily Coping 20 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

The Diverse Data Platform–Dativerse.io

By

The other day I got a note from Ben Weissman the other day that...

Extended Events and Azure SQL Database

By

Knowledge of how your system behaves is vital to better control, maintain, and grow...

Read the latest Blogs

Forums

usage of BCP and BULK INSERT

By 892717952

as I'm not clear how to use bcp and bulk insert in the following...

sequence of SQL server execution plan

By 892717952

As per my understanding,  when we read the execution plan, the sql server is...

An Empty Integer Numpy Array

By Steve Jones - SSC Editor

Comments posted to this topic are about the item An Empty Integer Numpy Array

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers