I disagree with explanation, the error generated

Msg 4104, Level 16, State 1, Line 2

The multi-part identifier "o.object_id" could not be bound.

it's not caused by CROSS APPLY, but a reference...

I think they started earlier with stored procs ('90): sql 6.0

The "order by" clause misses!

Try this:

declare @image as table (

row_id tinyint

primary key clustered (row_id desc)

);

insert into @image(row_id)

values(1),(2),(3),(4),(5),(6),(7),(8),(9)

select

case

when max(i.row_id)...

Ed Wagner (12/18/2015)

---

Carlo Romagnano (12/18/2015)

---

In case of shortening or if the type is CHAR/NCHAR the following error is raised:

Msg 5074, Level 16, State 1, Line 17

The index 'IX_MySales_CustomerReport' is dependent...

In case of shortening or if the type is CHAR/NCHAR the following error is raised:

Msg 5074, Level 16, State 1, Line 17

The index 'IX_MySales_CustomerReport' is dependent on column 'OrderStatus'.

Msg 4922,...

Here's a method to move resource database:

http://www.sqlnotes.info/2012/01/06/new-way-to-relocate-resource-database/[/url]

I never tested it, but, it seems to work.

That's true

🙂

I disagree, naming conventions should reflect the factory needs. So, it may be that [Sales.XXX] is good in some environment.

If I want to be pedant, the right answer is "All of the above".

Because of lacking of batch separator "GO".

If you run the script no procedure is created.

paul 25096 (11/4/2015)

---

I think the reason "Options 1, 2 and 3" has more votes than "Option 2" is because of course you should also avoid statements that cause a syntax...

Excellent!

I get it wrong because I forgot this from BOL:

READUNCOMMITTED and NOLOCK hints apply only to data locks. All queries, including those with READUNCOMMITTED and NOLOCK hints, acquire Sch-S (schema...

Easy questions.

Thanks!

😀

But, what happen?

Interesting question!

Thanks.

Toreador!

Default collation is case insensitive.

😀