Rodan Sotto's Tech Blog

Bit If you use bit, say to represent a boolean value, you are actually not allocating 1 bit but 1 byte.  The first bit will give you 1 byte and the next 7 bits will use that byte so if you declared 8 columns in your table of data type bit, they will all share the same byte.  If these are all nullable, or just even one, another byte is allocated... Read More

Besides the standard comparison operators (=, >, <, etc.), the boolean operators (AND, OR, NOT) and the BETWEEN operator, you can also use LIKE, IN, ALL, ANY, SOME, and EXISTS. LIKE Use this when you want to match the value of a column to a string with wildcard characters specified after this keyword.  You use % to mean 1 or more charact... Read More

model and msdb are among the 2 of the 4 system databases in SQL Server 2005, the other 2 being the master and tempdb.  model is a template for creating new databases so this is where you might want to add additional objects (e.g. tables, stored procedures, user defined types, etc.) that you want your new databases to have when you create them. ... Read More

I have worked on Access database for a long time now and recently worked on SQL Server 2005 Express.  I did some SQL Server stored procedures and triggers before that but it has been a while.  So now I told myself why not learn more about it and post my new found knowledge on a blog site and so this came about.  I just got a book by Robert Vieir... Read More