Rodan Sotto's Tech Blog

There are actually 4 joins in SQL Server: INNER, OUTER, CROSS, AND FULL.  If you come from an Access background, you already know INNER, OUTER, and CROSS joins. INNER JOIN is the default join in SQL Server so any SQL statements that has only JOIN in it is, by default, an INNER JOIN.  Use this type of join if you only want to include records whe... Read More

You can insert a DEFAULT value for a column instead of a NULL value if the column has a default value defined in it: [INSERT](http://search.microsoft.com/default.asp?so=RECCNT&siteid=us%2Fdev&p=1&nq=NEW&qu=INSERT&IntlSearch=&boolean=PHRASE&ig=01&i=09&i=99) [INTO](http://search.microsoft.com/default.asp?so=REC... Read More

You can use the INFORMATION_SCHEMA views to get the metadata on any database: SELECT * FROM INFORMATION_SCHEMA.TABLES You can also get information on table columns, table constraints, etc.  You can check what views are available by going to the System Views node under the Views node of the database from the Microsoft SQL Server Management Stud... Read More

My wife is into Oracle and recently she had this problem of importing data from Access to Oracle using [SQLLoader](http://www.oracle.com/technology/products/database/utilities/htdocs/sql_loader_overview.html).  What she was doing was export the Access data to CSV text file first and then have SQLLoader import this CSV text file.  I helped her de... Read More

Validation Controls You also have the ability to put some validation onto your controls using some of the available validation controls. RequiredFieldValidator will check if the control you assigned to it (ControlToValidate) has a value.  Other properties you can set are Text, and ErrorMessage.  Text is displayed when no value is entered for t... Read More