Viewing 15 posts - 1,921 through 1,935 (of 3,047 total)
You mean the results can't be guaranteed. They certainly can be determined simply by running the query.
November 11, 2015 at 7:20 am
SQLRNNR (11/5/2015)
I don't know about powershell punctuation, but tsql punctuation seems to be taking over mine. I keep ending all of my statements in a semi-colon.
Hmmm, haven't found the need...
November 11, 2015 at 6:59 am
tripleAxe (11/11/2015)
My current affliction is trying to use all my favourite SSMS keyboard shortcuts in other editors; 🙁
Oh, I've done the same thing. My fingers just know what to do...
November 11, 2015 at 6:58 am
I hate people refactoring code. They always seem to introduce errors into code that was running OK before they put their mits into it.
November 11, 2015 at 6:51 am
I see the link got fixed from yesterday. Thanks for the article.
November 11, 2015 at 6:49 am
SQLBill (10/19/2004)
No. You have it backwards. SQL Server interprets an empty string as a 0 not the other way around.
' ' = 0
but
0 = 0
-SQLBill
Correct
November 10, 2015 at 1:20 pm
Yelena Varshal (12/6/2004)
Look, Briscoe, BOL says:
"...can initiate automatic failover if the principal server instance fails..."
It is failover, not failure. But, you are right. Too much "Law and Order" for Microsoft...
November 10, 2015 at 6:50 am
iain.jacob 29849 (11/10/2015)
There is always another way...WHERE js.next_run_date = cast(convert(varchar(8),GETDATE(),112) as int);
Now that's the answer I was looking for.
November 10, 2015 at 6:44 am
I had to check the table structure of sysjobschedules. I would never have guessed that a date column was put into a purposely constructed int.
November 10, 2015 at 6:43 am
Over the years I think I've written some of that scary code. If something needs changing then change it. But I am not a proponent of just changing code because...
November 10, 2015 at 6:30 am
The GO is withing the commented block. So nothing in there means anything. Just the last select of getdate()+2 is executed. I think the answer given is wrong.
November 9, 2015 at 1:45 pm
vssohal (12/16/2004)
Correct answer should be Currentdate + 2
If you try to execute the script by using Ctrl+c and Ctrl+v in query workbench
you will get the above said result<FONT color=#008000...
November 9, 2015 at 1:45 pm
Viewing 15 posts - 1,921 through 1,935 (of 3,047 total)