microsoft sql
Converting VARCHAR to DATETIME
Recently a post was made on LinkedIn asking how one would convert a date stored in a VARCHAR field could be converted to a DATETIME so date math could be
Latest
microsoft sql
SQL Injection License Plate
While it would be nice to put my knowledge of SQL to work in such a way, I highly doubt this injection attack would do much to prevent getting a
SQL201
UNION, INTERSECT, and EXCEPT
Earlier today I was discussing methods you can use to differences in data sets between two tables or views. My colleague was discussing the usual
Posted in: Microsoft SQL
SQL 201-Formatting Dates in Microsoft SQL
One of the more frequent questions I get for SQL Server is how to format a DATETIME into a specific date format. Here’s a summary of the different date formats that come standard in SQL Server as part of the CONVERT function. Following the standard date formats are some extended...
microsoft sql
Could my Stored Procedure cause Performance Issues?
Problem originally posted at experts-exchange. I have 3 major stored procedures, meaning they are the backbone of my application. I built them to be as dynamic
career development
New Job
After several months of consideration, I've changed jobs. I'm now at Wachovia in the university area. It's much closer, My commute is just 12 miles now! I'm
SQL301
SQL 301 – GROUPING
In our previous lesson we covered WITH ROLLUP and WITH CUBE. During that lesson you may have noticed that when we saw the summary rows, the columns had NULL as
book reviews
The Adventures of Lando Calrissian #1
You must be aware by now I'm a Star Wars fan. So it should come as no shock, I just finished the first book of The Adventures of Lando Calrissian, The Mindharp
SQL301
SQL 301 — WITH CUBE and ROLLUP
Have you been asked to summarize some data into a nice report for management? They want to see subtotals and grand totals you say? You don't have to drop the
microsoft sql
Sample Databases for SQL Azure
Ready to head into the clouds and try your hand at a version of SQL quite different from those you know today? Sign up for a SQL Azure account, then grab this
microsoft sql
Sample Databases for SQL 2008
Now that many of us are upgrading to SQL 2008, we need a new sample database. If you've obtained a copy of SQL 2008 Developer Edition, if not, check out Amazon!
microsoft sql
Sample Databases for R2
..or as I call him, Ar-too. In case you haven't heard, SQL 2008 R2 has been released as a preview. If you have downloaded it, and are looking for a sample