TinySQL is small and handy SQL script which can quickly generate consistent code snippet that you can paste in your project. It basically operates by reading schema of provided table and applying template to each column of table in order to generate code snippet. With TinySQL, you can create complete or specific portion of business class, business service, or data access layer. You can also generate repetitive code snippet like storing all DataReader columns into respective property of business object, ......
Managing a Tree Using hierarchyid ---------------------------... Although a hierarchyid column does not necessarily represent a tree, an application can easily ensure that it does. When generating new values, do one of the following: Keep track of the last child number in the parent row. Compute the last child. Doing this efficiently requires a breadth-first index. Enforce uniqueness by creating a unique index on the column, perhaps as part of a clustering ......
The Web, Cloud and SaaS models are changing the computing world forever, and us, the developers will have to adjust and serve this trend. One of the biggest challenges is moving software assets that were developed for desktop architecture to the new deployment models. Just imagine that you could Copy/Paste your .NET code into a development framework , do some minor adjustments into multi users environment, decide whether you want to retain your desktop user interface (it could be ported 1:1 ) or ......
A wall of design ideas, web trends, and tutorials.
Tutorials, news, funky design techniques and everything in between.
http://www.webdesignerwall.com/
I have an Oracle background. It was interesting to see how rollback handled in Oracle and SQL Server. There is no begin trans in Oracle. What oracle does is it will store the data in a temporary area called the rollback segments. Untill your issue the commit command the records will be kept there. You can even rollback your update statement by issuing the rollback command. When you issue the commit command the records in the rollback segments are written to the redo log files. The same logic for ......