Case Insensitive Camparison remains a problem for most developers since SQL Server not supports any built in function for these purpose here is one wich compares varchar strings and returns 1 is mathes and 0 other wiseselect dbo.CampareCaseInsensitive('A','a')
2007-03-29 (first published: 2007-03-08)
78 reads
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
2007-03-21 (first published: 2007-02-24)
188 reads
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
548 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers