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 (124 total posts)
  • 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