Back To Basics: Views, what exactly are they?
Views are strange objects. They look like tables, can be queried like a table, but they don’t store any actual data. Think of them as a virtual table which has pointers back to the source tables.
Back To Basics: Tables, without them we have nothing to do
Tables are the core of any database platform. Without tables we would be able to process data, but we would have no way to store the data. In the simplest terms tables look like Excel sheets. They both have columns and rows.
SQL Server 2008 changes the way that CONVERT/CAST works
Normally when running a query against a table and using a CAST or CONVERT function against a datetime field any index is made useless. In SQL Server 2008 this problem is fixed. Microsoft has come up with a way for SELECT statements which use CAST or CONVERT against a column of the datetime datatype to […]
New INSERT syntax in SQL Server 2008
One of the very cool new feature which SQL Server 2008 gives us is an change to the INSERT statement. Now you can specify multiple rows to insert into a table from a single insert command.