Syntax error SQL 90 as well.

Care to comment as to why it returns this error in SQL 80 AND 90?

DECLARE @sampleString VARCHAR(1000) = '#This is a sample string# between two delimiters'

"Msg 139, Level 15, State...

The only difference between raw data and "information" is the format.

Apparently, someone at Sprint mistook this for knowledge.

That is ignorance.

Flexibility is a function of complexity.

When the technology isnt appropriately abstracted it's harder to use and ends up getting in the way.

Often the very need for another layer isnt understood....

A new field of study "Culturomics" and a new job description "Data Scientist"

True Conversation from Tuesday as my boss seagulled in @ 4:45pm.

"Your priorities for this week are projects A,B&C! We dont know anything about them, have no dates and the contracts...

The target environment was undefined so "an error" is a valid answer. ?

Server: Msg 170, Level 15, State 1, Line 5

Line 5: Incorrect syntax near 'MAX'.

Server: Msg 170, Level 15,...

FROM http://www.mssqltips.com/tip.asp?tip=1791

1. Rebuilding the Clustered Index (CI) does not rebuild the Non-Clustered Indexes (NCI) unless the keyword ALL is specified, you will have do it separately.

2. If...

Jack Corbett (9/12/2008)

---

Bill,

I'm not sure what you are exactly asking. Are you mentioning that if you just run the Selects you have listed in SSMS you get the same...

Then why is it that regardless of session or db settings SQL90 returns "A A" for

select 'A' + 'A'

and

select 'A ' + 'A'

Is that because theres still...

Growing the t-log is an expensive operation.

The assumption behind not physically truncating it is that it got this big once before therefore it will get this big again.

If...

Production versions of the t-log concept as applied to RDBMS pre-date the ARIES work by at least 10 years.

INGRESS,DB2 and PROGRESS had it in the late '70 and early 80's....

Nice article,

Just a small history.

Transaction logs being nescessary for transaction rollback and rollforward as defined by Codd & Date in the early 1970's have been part of RDBMS...

The answer is wrong. START_DT isnt even in the query.

I want my money back ;=)

Never mind.

Thanks