The correct answer is "it depends."

MOST of the time you'll get two rows as explained in the answer.

HOWEVER, each GETDATE() within each SELECT is evaluated separately. When the separate evaluations...

roger.plowman (8/23/2016)

---

sknox (8/23/2016)

---

roger.plowman (8/23/2016)

---

ANSI_WARNINGS are basically concerned with Null values (ignoring the divide by 0 issue which is really a seperate one). I believe the better solution is never allowing...

roger.plowman (8/23/2016)

---

ANSI_WARNINGS are basically concerned with Null values (ignoring the divide by 0 issue which is really a seperate one). I believe the better solution is never allowing Nulls in...

That is because it's in the standard:

SQL-92 section 20.2 <direct select statement: multiple rows> General Rule...

It's new in 2014SP2 -- and not in 2016 (yet).

Ed Wagner (8/15/2016)

---

Nice article, David. Like Jeff pointed out, if people have an irrational fear of xp_cmdshell, what are they going to think about Bash? I don't have...

Sergiy (8/14/2016)

---

There are other aspects which were not mentioned by anyone.

1. The same small query populating a temp table may be reused in several procedures.

In such case its plan will...

Stan Kulp-439977 (8/12/2016)

---

One trick I use is to write stored procedures using temporary tables, then when the stored procedure is finished and working go back through it and turn the...

TomThomson (8/4/2016)

---

Steve Jones - SSC Editor (8/4/2016)

---

You...

david.gugg (7/25/2016)

---

I think this kind of makes sense if you come at it from the Oracle perspective. In Oracle, to select values you have to go against the SYS.DUAL...

Jeff Moden (7/20/2016)

---

Agreed. There's not a "good" official MS reference that explicitly states how such compound operators work with respect to the right-hand expression but... if you make the...

And 0 would rank...

In parameter declaration, @parameter type = defaultvalue, the part after the equals sign is a default, not an assigned, value.

In T-SQL, parameter default values must be...

Carlo Romagnano (6/30/2016)

---

The second option is useless, but it also is correct.

SELECT @p = N'@m varchar(200)="event message", @d datetime=getdate(), @U varchar(10)="Steve" '

I.e. this code returns 1 despite @p...

prathmanu (6/28/2016)

---

Great Post for the starters.I am a newbie in SSIS and BIML ,this post explain how to implement incremental load for single table. But is there any logic in...