






List All the Tables with a Foreign Key Constraint
Just execute this code in Query Analyzer in SQL Server: sp_msforeachtable ‘select ”?”,objectproperty(object_id(”?”),”Tablehasforeignkey”)’
Just execute this code in Query Analyzer in SQL Server: sp_msforeachtable ‘select ”?”,objectproperty(object_id(”?”),”Tablehasforeignkey”)’
The decision to use virtual functions is a simple matter. You just need to know when you’d want to override a base method. Take the following code as an example:
This recursive function retrieves a hierarchical tree structure from a table with just four columns that describe each node in the tree: Level (the depth of the node in the
Often, in financial applications, the quarter end date is very important for financial calculations. The following function gets the end date of a Financial Quarter that is relative to the
Suppose jarFile is the jar/zip file to be extracted. destDir is the path where it will be extracted: java.util.jar.JarFile jar = new java.util.jar.JarFile(jarFile);java.util.Enumeration enum = jar.entries();while (enum.hasMoreElements()) { java.util.jar.JarEntry file
n my last article, “Extending Eclipse with Helpful Views,” I explained how easy it was to create new functionality in Eclipse. This article continues in the same vein by also