THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » T-SQL   (RSS)
Showing page 13 of 13 (126 total posts)
  • The joys of a calendar table (ytd, month, and quarter summations)

    There was a question on the forums the other day that asked how to get a total for the current month, the current quarter, and year to date.  It is actually a pretty easy task when using a calendar table.  I have one you can use here (I fixed an error in it that I just found too!): ...
    Posted to Louis Davidson (Weblog) by drsql on December 9, 2006
  • iPod and iTunes - Parsing the XML Library

    So I was trying to figure out a way to get my iTunes/iPod music library into SQL Server. Unfortunately, the XML in the library is not the easiest with which to work. Here is an abridged version of that XML: <plist version=''1.0''>   <dict>      <key>Major ...
    Posted to Peter DeBetta's SQL Programming Blog (Weblog) by Peter DeBetta on December 5, 2006
  • There is still stuff I hadn't noticed (OBJECT_ID has a parameter for type of object)

    I was building a script to build a table I had built in my dev environment including inserts so I did a bit of hunting around and came upon Vyas's script (http://vyaskn.tripod.com/) that is used to generate inserts from a table (script here: http://vyaskn.tripod.com/code/generate_inserts_2005.txt).  Very cool stuff and worked nicely (all I ...
    Posted to Louis Davidson (Weblog) by drsql on December 3, 2006
  • Constructive versus Deconstructive

    I have been struggling to find a way to describe the fundamentals of first normal form for my PASS presentation, and this came to mind last night.  SQL works in a very constructive way, meaning that if you have base values (commonly referred to as atomic, or scalar values) then you can build up the view that you want.  However, have ...
    Posted to Louis Davidson (Weblog) by drsql on October 18, 2006
  • Another reason to hate quoted identifiers...

    I was working with the Redgate compare tool today (something I am a big fan of I might add,) using it to take a snapshot of my database so I could drop all code and do a collation change to a database (an article I updated because I discovered a new wrinkle with computed columns needing to be modified.) When I got to that point in the process ...
    Posted to Louis Davidson (Weblog) by drsql on October 1, 2006
  • Easier access to metadata coming soon to a SQL Server near you

    This is not a scoop or anything, but it is quite newsworthy.  It is also a good way to kick off my sqlblog er...blog: Kalen Delaney - Metadata PowerSimon Sabin - object_name() to be extended in SP2 A very common request is to have some of the system functions to work in any database.  Kalen posted a piece of feedback on ...
    Posted to Louis Davidson (Weblog) by drsql on September 25, 2006
« First ... < Previous 9 10 11 12 13
Privacy Statement