GilaMonster (12/29/2010)

---

The columns just need to be there, it...

Gianluca Sartori (12/29/2010)

---

Both. In reverse order....

ronmoses (12/21/2010)

---

For educational purposes, I would genuinely appreciate it if one of the folks who take issue with the "most of the time" factor could illustrate a scenario in which...

Just to point out that this code:

IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE name like '#Customer%')

DROP TABLE #Customer

is NOT the proper way to test for the existence of a temporary...

Just to ensure that I understand this correctly: if you explicitly add the CI column(s), they won't also be implicitly added?

Okay, I'm staying up too late. Watching Craig Ferguson, and a viewer asked what is the good answer in a job interview for "what are your weaknesses". Craig's answer: Job...

Okay, let's talk about blogging. I've seen a few posts from time to time, but I don't recall seeing anything dealing with:

(From a higher level) How to set up a...

Actually, it's SSMS 2008 that utilizes those DMVs to produce the...

Jeff Moden (12/28/2010)

---

It may not matter but it looks like that code will find table and view names in comments, as well, which...

This will get a list of all datasets (tables/views) referenced in the definition for all procedures, with some limitations:

1. If you have 2 tables named "Table1" and "Table11", and the...

I went this route a few years ago....

If it will always be the first two characters that you want removed, just use the STUFF function:

declare @str varchar(500);

set @str = '| hello | world | I love sql...

GSquared (12/27/2010)

---

The first part is easy. It can be done in one Insert...Select if you just use the Row_Number() function.

IF OBJECT_ID(N'tempdb..#Numbers') IS NOT NULL

DROP TABLE #Numbers;

CREATE TABLE #Numbers (Number...

This is one of the things that I tried to...

Here's a method that utilizes a small, recursive CTE:

;WITH Months (N, MyDate) AS

(

-- get the first day of the current year

-- N is the MonthNumber

SELECT 1, DateAdd(year, DateDiff(year, 0, GetDate()),...