SQL BUILT IN FUNCTIONS PART – 2 In my last SQL BUILT IN FUNCTION ARTICLE ASCII & CHAR has been described, today the REPLACE system function provides the functionality of replacing all occurrences of a given value with another value. This system function is valuable for masking processes. If the value...
SQL BUILT IN FUNCTIONS PART –1 The ASCII and CHAR system functions provide the conversion functionality between character values and ASCII code values. These system functions are valuable when iterating through characters, mathematically determining characters and randomly deriving characters. The American...
Posted to
Rahul Kumar Ghosh's Blog
by
rahul kumar ghosh
on
07-19-2011
Filed under:
Filed under: ASCII, master..spt_values, CHAR, DATA TYPE, DATATYPE, TEMPORARY TABLE, SUBSTRING, WHERE, TABLE, SELECT, BRH
This post follows my previous two posts about datetime http://beyondrelational.com/blogs/madhivanan/archive/2010/05/25/understanding-datetime-column-part-i.aspx http://beyondrelational.com/blogs/madhivanan/archive/2010/05/25/understanding-datetime-column-part-ii.aspx Now we will see some example queries...
There are N number of questions asked in the forums about handling dates in query Most of the people who ask questions dont understand how datetime column works in SQL Server Some of the questions frequently asked are about 1 using dates in the WHERE caluse 2 formatting dates using SQL 3 inserting dates...