OK, what you really want is setup like this, so someone can test (And you can).

create table a

(

aguid int

, fbnum int

, mydate date

, aType varchar(10)

)

go

create table b

(

...

I agree with you, Gary. So many people want this simple, and it's not. Many of the complex migrations in Oracle (column splits, drop column, etc), often have triggers to...

Couple things you need to clarify.

First, what's the first row? There's no such thing in a SQL table. Until you do an ORDER BY in a query, you can't determine...

No purpose. Just a design decision by MS.

Jack Corbett (3/22/2016)

---

On personal note, my 17 year old daughter, is the NH State Champion for Poetry Out Loud[/url]. She gets a trip to Washington D.C. for...

glad you're OK. Sad days.

BL0B_EATER (3/22/2016)

---

Does anyone else have an issue during submitting an article when you paste in some TSQL into the SQL snippet block and save it then go back to it...

Alan.B (3/21/2016)

---

Quick question: I got the standard email saying that someone replied to a comment on one of the forum threads but when I go to that thread the comment...

Seems mixed.

I'll say that standing for a few years now, that I...

I use online for most of this, for the reasons you mentioned. Even if you want to use local, sometimes Google helps you narrow the topic.

Can I ask what you...

Please start a...

What is "looks very busy"? How can you measure this? What do you look at in performance monitor?

Good catch and thanks

Apologies on the versioning.

SQL 2008R2 and below are no longer supported from MS as they are too old. Typically the current version(s) should be used, though I changed the question...

hence my statement. I was agreeing with Gary. Just wanted to clairfy.