Browse by Tags

sp_MSForEachDB - leashed and unleashed

First things first - a few words on Microsoft undocumented procedures (and tools): it is this simple - USE THEM WITH CAUTION. There are several out there, and they are all great. If you compare sp_who (documented) with sp_who2 (UN-documented) you will...

Published 9 Oct 2009 11:56 AM by Feodor Georgiev

Filed under: stored procedures, parameter, Intermediate SQL, sp_MSForEachDB, Business Intelligence, undocumented procedures, filter, parameters

Splitting a string into a table of characters

Sometimes you may not be able to see the characters in your data in SQL Server Mangement Studio (or another application). This simple function will allow you to pass an input string in, and it will return the individual characters as rows from a Table...

Published 24 Mar 2009 11:55 PM by BrandonGalderisi

Filed under: Intermediate SQL, Beginner SQL, table valued function, User Defined Functions, Advanced SQL

Updating values in one table with values from another table

Sometimes, it is necessary to update a field in one table, with information from another table. In this article, I will go over with you a few different methods for doing this. At the bottom there is a link to download the entire SQL script used in this...

Published 19 Mar 2009 5:24 PM by BrandonGalderisi

Filed under: Intermediate SQL, UPDATE, JOIN

Converting a delimited string into a table

In this article, I will show you how you can convert a delimited string of data into a table of data. In order to do this we will use a table valued function. There are many ways to achieve this but this how I like to do it. In order to use the function...

Published 7 Mar 2009 12:25 AM by BrandonGalderisi

Filed under: Intermediate SQL, function, numbers table, table valued function, numbers, User Defined Functions

Changing the display format of DATETIME values

Often times, people want to change the format of a datetime value returned from SQL Server. There are some things that you need to consider before doing this. The first thing that you need to be aware of is that SQL Server stores DATETIME values in an...

Published 5 Mar 2009 10:24 PM by BrandonGalderisi

Filed under: datetime, time, date, cast, convert, Intermediate SQL

Syndication

Recent Posts

Tags

Archives

sp_MSForEachDB - leashed and unleashed

Splitting a string into a table of characters

Updating values in one table with values from another table

Converting a delimited string into a table

Changing the display format of DATETIME values