+1

Both are reasons I started to try and use this in my code, until...

ronmoses (4/17/2015)

---

I'm not sure it's accurate to say "all need to be of the same data type." I believe all need to be able to be implicitly converted to the...

jackimo (4/15/2015)

---

Query tuning really isn't my forte, but the interesting thing is that I can break this query down into 3 steps (1 first small select, 2nd larger select and...

pmcpherson (4/15/2015)

---

My favorite part of today's strip about compression is the "TILT!" on the screen. I wonder if the under 30 crowd gets it as a pinball reference. ...

Here is some code I borrowed from someone, it searches across all databases on the server.

DECLARE @sql VARCHAR(8000)

DECLARE @SearchText NVARCHAR(255)

SET @SearchText = 'table_name_here'

DECLARE @Results TABLE

(

[SERVERNAME] VARCHAR(255),

[DBName] VARCHAR(255),

[NAME]...

Sean Lange (4/7/2015)

---

below86 (4/7/2015)

---

Sean Lange (4/6/2015)

---

Why do you need to use dynamic code here? I see that you have a list of values in your variable but if those were...

Sean Lange (4/6/2015)

---

Why do you need to use dynamic code here? I see that you have a list of values in your variable but if those were broken out you...

Gary Varga (3/31/2015)

---

Good spot...but no. Still eminently watchable. (Only considering Alien and Aliens - particularly...

Gary Varga (3/31/2015)

---

Good spot...but no. Still eminently watchable. (Only considering Alien and Aliens - particularly...

Maybe it's time for an Aliens remake?

Over this past weekend I had free Starz channels and the movie Meatballs was on. I was about to set my DVR to record it when I remembered this...

But not all, I watched the movie 'About Last Night' from the 80's with Rob Lowe...

Eric M Russell (3/23/2015)

---

below86 (3/23/2015)

---

I loved that show.

I ran into this same issue with...

I loved that show.

I ran into this same issue with a couple movies. ...