Like the article.

I'd like to point to the fact that "PRINT @SQL;" is limited to 4000 characters, therefore I use "SELECT CAST('<root><![CDATA[' + @SQL + ']]></root>' AS XML)".

Don't...

TheSQLGuru (6/8/2016)

---

tomd-982312 (6/8/2016)

---

Guys, this topic is not about efficiency, or RBAR, or order by, or dbms_output.put_line().

I'm just trying to find simple code that reads sequentially row by row from table....

frederico_fonseca (6/8/2016)

---

tomd-982312 (6/8/2016)

---

drew.allen (6/7/2016)

---

This type of processing is referred to as RBAR (Row By Agonizing Row), because it is a HORRIBLY inefficient approach in the vast majority of cases. Why...

Guys, this topic is not about efficiency, or RBAR, or order by, or dbms_output.put_line().

I'm just trying to find simple code that reads sequentially row by row from table. It's a...

drew.allen (6/7/2016)

---

This type of processing is referred to as RBAR (Row By Agonizing Row), because it is a HORRIBLY inefficient approach in the vast majority of cases. Why don't you...

Good article and not that good example.

1. Joining type - Inner Join

> intersection of two tables

2. Joining type - Left Outer Join (aka Left Join)

> all from left (first) table and only those from right (second)...

Yes, it is arrogance. :sick:

It's screaming "I am American/English/whatever and you're not!", "I speak perfect english and you don't", "I'm an arrogant bastard and you kiss my ...".

Arrogance at it's...

You can add an unconditional WHERE part.

... SET @sql = ' SELECT * FROM Production.Product WHERE 1 = 1 '...

Now you are sure that every other condition should begin with...