(Serdar Yegulalp) In SQL Server 2000, there was really only one way to create a stored procedure: as a T-SQL statement. That was the course to take in every previous edition of SQL Server. But SQL Server 2005 makes it possible to write stored procedures (and functions, triggers and a number of other
Other News
Partitioned Tables in SQL Server 2005
(Nigel Rivett) Partitioned tables are a new feature available in SQL Server version 2005, aimed mainly at improving the performance of large database systems. The feature is only available for enterprise and developer edition. For other editions you can get a similar functionality with a partitioned
Construct your .NET application with MSBuild
(Tony Patton) The arrival of the .NET Framework 2.0 introduced many features, including the new build process driven by the Microsoft Build Engine (MSBuild). This article offers an overview of the tool, along with basic examples.
Quickly find foreign-keys depended tables
(David) Today I needed a quick way to find out all of the tables foreign keys are referencing for a given table. That is, if I have a table named TABLE1 which has a few foreign keys defined on it, I want a list of all the tables these foreign keys are referencing.
Ruby on Rails and XML
(Daniel Wintschel) You’ve very likely heard of Ruby on Rails. Maybe you’ve actually used it; perhaps it is your new programming mistress. Whatever the case, it looks like Rails is here to stay, and to everyone’s benefit. Ruby plays very nicely with XML — read further for the details. (R)
Take the control of TIME Part1 (Introduction to Date/Time)
(Coskan Gundogar) In todays world data is controlled by time and if you don’t know how to control the time, you can’t have enough control over your data. Thanks Larry Ellison and his employees for building Oracle with powerful time manipulating functions and datatypes which you have to know to admin
XSD Tutorial – Part 1 of 5 – Elements and Attributes
(Simon Sprott) First lets look at what an XML schema is. A schema formally describes what a given XML document contains, in the same way a database schema describes the data that can be contained in a database (table structure, data types). An XML schema describes the coarse shape of the XML documen
Setup user account and database in SQL Server 2005
(Svetoslav Marinov) I assume that you have configured correctly MS SQL Server 2005 to accept remote connections so we start our short tutorial.
XAML Layout using the Panel Class
(Doug Cook) Avalon provides a number of options to achieve complex layouts. The framework supports an integrated set of components as part of a single, flexible layout model that has been optimized for content presentation.
Creating a Code Search Engine with PHP and MySQL
(Jason Gilmore) I’m just a few days away from launching a comprehensive support website for my book, “Beginning PHP and MySQL 5, Second Edition”, and among other features, have built a search engine for sifting through the more than 500 code snippets found throughout the book. This was an interestin