Viewing 15 posts - 2,431 through 2,445 (of 26,488 total)
November 11, 2017 at 12:00 am
November 10, 2017 at 5:45 pm
November 9, 2017 at 11:43 am
November 8, 2017 at 9:15 am
November 8, 2017 at 7:51 am
Because it isn't adding 32 to the date time value:
NewDate DateAsBinary NewDateAsBinary
----------------------- ------------------------------------------------------------------ ------------------------------------------------------------------
2001-01-01 00:00:00.107 0x0000901A00000000 0x0000901A00000020
November 7, 2017 at 11:50 am
November 7, 2017 at 9:03 am
Let's just say things could be a lot better. Didn't really get good news yesterday. There is a strong possibility the bone broke due to cancer. Simply put, I'm scared.
November 7, 2017 at 6:45 am
November 5, 2017 at 6:44 pm
So, today is not what I expected. My dad's right femur broke causing him to fall. He is in the hospital not sure when they will be doing the surgery. ...
November 5, 2017 at 6:00 pm
First, I must agree, find a better way than using a cursor. As an exercise, you would need something like this:
declare
@ErrorNumber int,
@ErrorLine...
November 3, 2017 at 4:17 pm
No cursor required:
DECLARE @SQLCmd NVARCHAR(MAX);
CREATE TABLE #results(dbName varchar(50), latestTimestamp datetime);
SELECT @SQLCmd = N'INSERT INTO #results' + NCHAR(13) + NCHAR(10) +
STUFF((SELECT N'union all' +...
November 3, 2017 at 9:00 am
Nevermind, bad advice.
November 2, 2017 at 3:22 pm
And for a change of pace, I am trying to help my daughter with her database class. What makes it fun is trying to remember my Oracle days (all one...
November 2, 2017 at 2:10 pm
Viewing 15 posts - 2,431 through 2,445 (of 26,488 total)