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...
Rahul Kumar Ghosh's Blog
rahul kumar ghosh
Filed under: Filed under: ASCII, master..spt_values, CHAR, DATA TYPE, DATATYPE, TEMPORARY TABLE, SUBSTRING, WHERE, TABLE, SELECT, BRH