Start to refer the books …. 1. Knuth‘s all the volumes (three) on programming/Algorithms. 2. Programming Perls 3. How to solve it by Computer by Dromey 4. Algorithms and DataStructures by Alen Wiss (standard datastructures)
Category: Programming
How to pass a list of values or array to SQL Server stored procedure?
Note: Information & code samples from this article are tested on SQL Server 2005 RTM (Yukon) and found to be working. Will update the article in case of any compatibility issues. unfortunately, there is no built-in support for arrays inContinue reading… How to pass a list of values or array to SQL Server stored procedure?
Java Common Utils: Creating a stored procedure or function in an Oracle Database
A stored procedure or function can be created with no parameters, IN parameters, OUT parameters, or IN/OUT parameters. There can be many parameters per stored procedure or function. An IN parameter is a parameter whose value is passed into aContinue reading… Java Common Utils: Creating a stored procedure or function in an Oracle Database
Java Common Utils: Calling a Stored Procedure in a Database (Oracle)
This example demonstrates how to call stored procedures with IN, OUT, and IN/OUT parameters. CallableStatement cs; try { // Call a procedure with no parameters cs = connection.prepareCall(“{call myproc}”); cs.execute(); // Call a procedure with one IN parameter cs =Continue reading… Java Common Utils: Calling a Stored Procedure in a Database (Oracle)
Java Common Utils: Reading and writing text files
When reading and writing text files : it is almost always a good idea to use buffering (default size is 8K) it is often possible to use references to abstract base classes, instead of references to specific concrete classes thereContinue reading… Java Common Utils: Reading and writing text files
Hiding Javascript Source
When you code an external javascript you identify that it is a javascript using either or both of the language and type parameters on the script tag. The file suffix of .js doesn’t get referenced in determining that the calledContinue reading… Hiding Javascript Source
Recursive execusion of commands in Linux command prompt
When we want to execute any command recursively for a directory, we can use find command for that. find . -name ‘blah*’ -exec rm -rf {} ; But some times, it gives the error as Argument list too long. InContinue reading… Recursive execusion of commands in Linux command prompt
Fast Bit Counting Routines
A common problem asked in job interviews is to count the number of bits that are on in an unsigned integer. Here are seven solutions to this problem. Source code in C is available. Iterated Count int bitcount (unsigned intContinue reading… Fast Bit Counting Routines
ActiveX Data Objects
The ADO Object Model ADO is a simple way of making a connection with a database, and issuing commands (such as stored procedures in SQL Server), or retrieving data into so-called RecordSets. ADO resides on top of OLE-DB (from withinContinue reading… ActiveX Data Objects
Python tips
The following statement can be used to evaluate the function get_context_english() …… eval(‘get_context’ + str(context))