March 12, 2020 at 1:24 am
Ah... thanks. I totally missed the link.
--Jeff Moden
Change is inevitable... Change for the better is not.
March 12, 2020 at 4:38 pm
as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same as NULL
Phil Parkin ducked out way too early on that request.
MVDBA
March 12, 2020 at 4:44 pm
as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same as NULL
Phil Parkin ducked out way too early on that request.
Not sure if that beats the conversation I just had on the phone, where they asked me to spell someone's email address, because they "couldn't open more than one email at a time in Outlook" to copy and paste the email I'd sent them with said email address in it. >_<
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 12, 2020 at 4:52 pm
as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same as NULL
...
Really depends on the RDBMS being used. At one point in my past when working with Oracle, it treated the empty string as null which is different from how MS SQL Server treats it. This initially caused me some issues as I was used to how SQL Server did things. Also, I believe there are setting that can change this behavior.
March 12, 2020 at 4:52 pm
MVDBA (Mike Vessey) wrote:as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same as NULL
Phil Parkin ducked out way too early on that request.
Not sure if that beats the conversation I just had on the phone, where they asked me to spell someone's email address, because they "couldn't open more than one email at a time in Outlook" to copy and paste the email I'd sent them with said email address in it. >_<
seriously Thom - you are just plain lazy - you should have hand delivered it in triplicate with a braille copy in case they were blind (as well as stupid) - none of this fancy copy/paste stuff for our users
MVDBA
March 12, 2020 at 4:57 pm
MVDBA (Mike Vessey) wrote:as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same as NULL
...
Really depends on the RDBMS being used. At one point in my past when working with Oracle, it treated the empty string as null which is different from how MS SQL Server treats it. This initially caused me some issues as I was used to how SQL Server did things. Also, I believe there are setting that can change this behavior.
it was SQL server - 2017, turns out the issue was he was coding in VB and passing the VB version of NULL (emptystring) and not DBNULL
hence set firstname=isnull(@firstname,firstname)
didn't work how he expected.
MVDBA
March 12, 2020 at 4:57 pm
seriously Thom - you are just plain lazy - you should have hand delivered it in triplicate with a braille copy in case they were blind (as well as stupid) - none of this fancy copy/paste stuff for our users
I would rather they were blind... Instead they're in charge of Payroll and expenses. :'(
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 12, 2020 at 5:06 pm
as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same as NULL
Phil Parkin ducked out way too early on that request.
Hahaha, had to 'duck out' of the office for a couple of hours and missed all the fun ...
March 12, 2020 at 5:21 pm
MVDBA (Mike Vessey) wrote:as for the original topic of this forum. I've just wasted 30 minutes of oxygen to have to explain (after no details added) that emptystring is not the same as NULL
Phil Parkin ducked out way too early on that request.
Hahaha, had to 'duck out' of the office for a couple of hours and missed all the fun ...
took your time to wade in at the end 🙂
MVDBA
March 12, 2020 at 6:23 pm
So an international academic writers conference (ICFA) that I usually am invited to as a fiction writer, and forgot to accept the invite last October, has been cancelled. I haven't read the email, I was just told by someone else. At a guess, though, there are worries about passing COVID19 around as well as the fact that many attendees come from the recently banned European countries and from countries that President Miller has been asking ICE to stop at the U.S. borders.
When I heard about COVID19, I was somewhat relieved I forgot about accepting the invite (and hence have no travel plans to cancel). I am not at all surprised today that the entire event is getting cancelled. But disappointed for all the graduate level students who were to present their theses at this event. This is going to hit them hard. Especially the ones who are trying to get attention for the next stage of their careers (and references).
March 12, 2020 at 6:42 pm
Shifting gears a bit... does AWS RDS support the Developers Edition of SQL Server? Also, any idea if they support 2019 yet?
No dev edition. No to 2019
https://aws.amazon.com/rds/sqlserver/pricing/
SQL Server Editions
Amazon RDS supports multiple editions of SQL Server (2012, 2014, 2016, and 2017) including Express, Web, Standard Edition and Enterprise Edition.
Not all editions may be available in all regions; see pricing for details.
March 12, 2020 at 6:46 pm
Sad here that the major volleyball tournament was cancelled. I coached last weekend for the younger kids, but the 16-18s were this weekend. I have kids at all ages I've coached and disappointed I don't get to see them and they can't play, but I think this was the right thing to do
March 12, 2020 at 6:46 pm
Earlier today the school announced that the band trip to Disney was cancelled. There was less than three to go before they got on the bus. Plane tickets, hotels, park tickets, meal vouchers all paid for up front through the school for the whole family. Looks like the virus has crippled me twice now. All told I have lost a little over $5k in cancellations for two trips with little to no chance of getting much more than a couple hundred back.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 12, 2020 at 7:10 pm
Sorry to hear that, Sean, and hope things go better for you. I've seen many updated policies lately that are suspending some of the cancellation fees and allowing rebooking. So far I haven't gotten charged for things I've cancelled.
March 12, 2020 at 7:15 pm
"Thank you for your kind donation to the local high school band program, in appreciation of your gift, a brick with your name has been placed on the entrance to the football field"
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
Viewing 15 posts - 64,621 through 64,635 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply