September 19, 2017 at 7:06 pm
Lynn Pettis - Tuesday, September 19, 2017 2:39 PMOMG! People are getting so literal! "I am not using a system table." Hey! It was an example! Get a clue!
Once upon a time, we were all newbies that might did not have known know better. 😉
I remember one fellow that responded to a post of mine as if I were the most vicious, underhanded, bloodsucker ever all because I conditionally dropped the Temp Table that was named exactly the same as his real table except that mine had the usual "#" at the beginning. He honestly thought I was trying to trick him into running my code to drop his table.
A lot of us came up to speed very quickly (to be honest, it took me longer than most) but we all started that way (especially taking things from "experts" as stated because they're the "experts"). At least he knew what sys.table was. 😉
Unfortunately, it's how a lot of so called "best practices" are born.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 19, 2017 at 7:22 pm
Luis Cazares - Tuesday, September 19, 2017 2:54 PMAlso, today is the 32nd anniversary of the most devastating earthquake that Mexico has faced, and there was a new one that collapsed several buildings. Please, keep the victims in your prayers.
One of our Developers grew up there and has family and friends there. He showed me a video of an 8 or 10 floor building that had very large pieces popping off of it and a drone shot of all the dust coming up from the city were smaller buildings had partially or fully collapsed. He's not been able to contact any of them yet because cell phone systems and towers took a major hit, as well.
Wishing you, yours, and your countrymen well, Luis.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 20, 2017 at 7:26 am
Jeff Moden - Tuesday, September 19, 2017 7:22 PMLuis Cazares - Tuesday, September 19, 2017 2:54 PMAlso, today is the 32nd anniversary of the most devastating earthquake that Mexico has faced, and there was a new one that collapsed several buildings. Please, keep the victims in your prayers.One of our Developers grew up there and has family and friends there. He showed me a video of an 8 or 10 floor building that had very large pieces popping off of it and a drone shot of all the dust coming up from the city were smaller buildings had partially or fully collapsed. He's not been able to contact any of them yet because cell phone systems and towers took a major hit, as well.
Wishing you, yours, and your countrymen well, Luis.
Fortunately, most of friends and family have indicated that they're safe. None is reported as missing. My wife and mother in-law were about to take the plane to come to Atlanta. Their flight got cancelled and they hope to be able to travel today.
At least 30 buildings fully collapsed, others have sever damages. Some were apartment buildings and some were schools with children in them. It's astonishing the multiple videos showing how buildings fall in seconds. But it's impressive how so many people have joined to help each other by offering shelter for victims, removing debris to look for people, bringing food, water and equipment to those people, offering internet access or phone calls.
September 20, 2017 at 7:46 am
Luis Cazares - Wednesday, September 20, 2017 7:26 AMJeff Moden - Tuesday, September 19, 2017 7:22 PMLuis Cazares - Tuesday, September 19, 2017 2:54 PMAlso, today is the 32nd anniversary of the most devastating earthquake that Mexico has faced, and there was a new one that collapsed several buildings. Please, keep the victims in your prayers.One of our Developers grew up there and has family and friends there. He showed me a video of an 8 or 10 floor building that had very large pieces popping off of it and a drone shot of all the dust coming up from the city were smaller buildings had partially or fully collapsed. He's not been able to contact any of them yet because cell phone systems and towers took a major hit, as well.
Wishing you, yours, and your countrymen well, Luis.
Fortunately, most of friends and family have indicated that they're safe. None is reported as missing. My wife and mother in-law were about to take the plane to come to Atlanta. Their flight got cancelled and they hope to be able to travel today.
At least 30 buildings fully collapsed, others have sever damages. Some were apartment buildings and some were schools with children in them. It's astonishing the multiple videos showing how buildings fall in seconds. But it's impressive how so many people have joined to help each other by offering shelter for victims, removing debris to look for people, bringing food, water and equipment to those people, offering internet access or phone calls.
Good to hear and fingers crossed! Find it incredible that it happened exactly 32 years to the day after the big one.
😎
September 20, 2017 at 7:54 am
Luis Cazares - Wednesday, September 20, 2017 7:26 AMFortunately, most of friends and family have indicated that they're safe. None is reported as missing. My wife and mother in-law were about to take the plane to come to Atlanta. Their flight got cancelled and they hope to be able to travel today.
At least 30 buildings fully collapsed, others have sever damages. Some were apartment buildings and some were schools with children in them. It's astonishing the multiple videos showing how buildings fall in seconds. But it's impressive how so many people have joined to help each other by offering shelter for victims, removing debris to look for people, bringing food, water and equipment to those people, offering internet access or phone calls.
Great to hear that your friends and Family are safe and accounted for. Hope that they are all well and have somewhere safe to stay.
Although what has happened is awful, it's great to see that there are times when whole communities pull together to save lives and help others who are worse off than them. The media is far too often filled with news of hatred and acts of Terrorism (North Korea's missiles, the recent failed bomb at Parson' Green (London), the HGV incidents by extremists in Europe, etc). The loss of life is a tragedy, but it's also refreshing to see that people do the opposite, and the lengths they go to to save lives, rather than take them.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 20, 2017 at 7:57 am
Eirikur Eiriksson - Wednesday, September 20, 2017 7:46 AMGood to hear and fingers crossed! Find it incredible that it happened exactly 32 years to the day after the big one.
😎
And they had an earthquake drill a few hours before the actual earthquake to commemorate that great earthquake.
September 20, 2017 at 8:48 am
Alan.B - Tuesday, September 19, 2017 4:44 PMSQL Server is so weird sometimes.
select 'a'+++++++++++++++++++++++'b'++++++++++++++++++++++++'c'
returns abc.
SQL is horribly broken. I know we're used to it, but
create table mytable (myid int)
alter table mytable add mychar char(10)
alter table mytable alter column mychar varchar(20)
alter table mytable alter column mychar add masked with (function = 'default()')
create procedure myproc
as
select 1
alter procedure myproc
@myid int
as
select @myid
are examples of horrible language design. If I made you write this:
public static void myMethod (int myparam )
{ // do something
}
and
change public static int myMethod (int myparam, int mysecond)
{
return myparam + mysecond
}
you'd move to Java.
September 20, 2017 at 8:54 am
Luis Cazares - Wednesday, September 20, 2017 7:57 AMEirikur Eiriksson - Wednesday, September 20, 2017 7:46 AMGood to hear and fingers crossed! Find it incredible that it happened exactly 32 years to the day after the big one.
😎And they had an earthquake drill a few hours before the actual earthquake to commemorate that great earthquake.
Good to hear that they're safe, Luis. I hope your wife and mother in-law get to Atlanta soon.
September 20, 2017 at 9:22 am
Luis Cazares - Wednesday, September 20, 2017 7:57 AMEirikur Eiriksson - Wednesday, September 20, 2017 7:46 AMGood to hear and fingers crossed! Find it incredible that it happened exactly 32 years to the day after the big one.
😎And they had an earthquake drill a few hours before the actual earthquake to commemorate that great earthquake.
I hope all your family is all fine mate! I do remember the '85 one, was supposed to be sent there but got diverted to other rescue work at the time.
😎
September 20, 2017 at 7:17 pm
Jeff Moden - Tuesday, September 19, 2017 6:56 PMAlan.B - Tuesday, September 19, 2017 4:44 PMSQL Server is so weird sometimes.
select 'a'+++++++++++++++++++++++'b'++++++++++++++++++++++++'c'
returns abc.Heh... yep... fun stuff.
SELECT '1,,,,,,'+$0, ',,,,,,1'+$0, '1,,,,,,1'+$0, '1,,,1,,,1'+$0;
Shut. The. Front. Door. the concatenation operator I understand completely. What the hell is going on with this one though.....
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
September 21, 2017 at 9:03 am
I have no idea. Precedence means that '1,,,,,' is converted to money, but I don't understand why the multiple separators don't cause an error.
September 21, 2017 at 9:34 am
I would guess the conversion routine simply drops all thousands separators, and then converts to a numeric type:declare @var money
set @var = ',1,00,00.99'
select @var
September 21, 2017 at 9:55 am
crow1969 - Thursday, September 21, 2017 9:34 AMI would guess the conversion routine simply drops all thousands separators, and then converts to a numeric type:declare @var money
set @var = ',1,00,00.99'
select @var
That might be a quick fix they chose to deal with different ways to separate digits, like indian notation.
September 21, 2017 at 10:09 am
Must be some artifact of dealing with various numeric notations. Still, strange.
September 21, 2017 at 2:46 pm
That is what I thought as well, Luis. After a bit more testing, I found that the money datatype is the only one that exhibits that sort of behavior. All other numeric types give an error trying to set the value from the string. Also, the money datatype can't take the extra thousands separators unless the value is passed as a string. Numeric literals need to conform to numeric rules. I have to admit, this was somewhat fun to play around with.
Viewing 15 posts - 59,956 through 59,970 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply