The Problem I was working on an ERP project for an electrical company. As a DBA my main task was to maintain database security and data consistency. A database developer was appointed on the client side to maintain the database. By mistake the developer used an update query in an important monetary transaction...
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