Good question, thank you. I really hope that nobody actually thinks that it is OK to abuse the database just because the engine allows it.

Oleg

I have read the blog by Lynn Pettis in the past, the conversions are definitely very useful. The convert function is simple enough though and should be OK to use...

Paul White NZ (6/2/2010)

Hey Oleg,

Log files are...

This is a good solution, but rtrim is not needed. Len function ignores the trailing (but not leading) spaces. In other words len('hello ...

You have 2 very small problems:

First, there is no need to cast HashConcatenateString as varbinary(20) because it is already spelled out and therefore, if you cast it to varbinary(20)...

Something like this should do it:

select convert(varchar(10), getDate(), 120)

The above returns 2010-06-02 when ran at any time today.

Hope this helps.

This is a great question, thank you Paul. It would have been very difficult to answer it correctly, but fortunately for me, incorrect options were clearly incorrect, and therefore it...

This is a great question, thank you Ron!

Hats off to the database engine team on this one, the implementation of the seeding next value in the direction of open waters...

I saw on other posts yesterday that line 359 hints that the database is near corruption, I just hope that this is not the case.

Oleg

Paul White NZ (5/21/2010)

Well you can, it just has to be unique and created...

Because they cannot, you can ask Steve to edit one of the lines...

I had to debug a painfully similar script about a year ago. The problem we had was limited to the enormous log file growth and ridiculously slow execution times. The...

There is nothing odd about the connection. Sev 20 errors do exactly that. From...

This is an excellent question, thank you. I thoroughly enjoyed it because I found it to be pretty difficult to answer correctly. I suspect that "most characters illegal" means all...

To do the opposite, you can simply get the difference in seconds between yor date column value and Jan 1 1970, i.e.

select

datediff(second, '19700101', '12/10/2009 6:34 PM') timestart,

datediff(second, '19700101', '12/10/2009 7:34...