<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Tom Thomson
»
Type conversions and Nulls
49 posts, Page 5 of 5
««
«
1
2
3
4
5
Type conversions and Nulls
Rate Topic
Display Mode
Topic Options
Author
Message
EL Jerry
EL Jerry
Posted Wednesday, February 06, 2013 10:07 AM
Hall of Fame
Group: General Forum Members
Last Login: Thursday, May 02, 2013 3:45 PM
Points: 3,748,
Visits: 928
Excellent question, Tom, and even better explanation.
"El" Jerry.
"A watt of Ottawa" - Gerardo Galvan
Post #1416627
Revenant
Revenant
Posted Wednesday, February 06, 2013 11:08 AM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 2:20 PM
Points: 3,462,
Visits: 2,539
Nice question - thanks, Tom!
Post #1416649
Christian Buettner-167247
Christian Buettner-167247
Posted Thursday, February 07, 2013 1:26 AM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 6:12 AM
Points: 2,526,
Visits: 3,620
Thanks for the question!
Best Regards,
Chris Büttner
Post #1416859
opc.three
opc.three
Posted Monday, February 11, 2013 7:14 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 6,737,
Visits: 11,791
Rob Schripsema (2/5/2013)
Great question, Tom
I
almost
wish you had thrown in an option of '2012-04-01 10:00:00.000' to spice up the thinking a bit more. Of course, then I probably would have gotten it wrong....
+1 to that
Nice question.
__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Believe you can and you're halfway there.
--Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler
--Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them.
--Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples.
--Giordy
Post #1418407
sqlcentral-bugmenot
sqlcentral-bugmenot
Posted Tuesday, February 26, 2013 6:44 AM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, May 02, 2013 3:04 AM
Points: 31,
Visits: 33
Wow, my first really wrong answer. I knew about CASE's type inferral, just forgot. Thanks for the exceptionally good question.
Post #1424061
David Conn
David Conn
Posted Wednesday, March 06, 2013 11:12 PM
SSCommitted
Group: General Forum Members
Last Login: 2 days ago @ 2:06 PM
Points: 1,689,
Visits: 656
I got caught by the Null. I work as a Programmer more often than not where some Languages automatically initialise a Variable at declaration time. The ones that don't tend to just leave the Variable with whatever is in its memory location. I would prefer Null as a default in these instances rather than garbage.
Post #1427778
opc.three
opc.three
Posted Wednesday, March 06, 2013 11:20 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 6,737,
Visits: 11,791
David Conn (3/6/2013)
The ones that don't tend to just leave the Variable with whatever is in its memory location.
Yikes, not sure I know (or knew or remember) which might do that. To which were you referring?
__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Believe you can and you're halfway there.
--Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler
--Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them.
--Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples.
--Giordy
Post #1427781
David Conn
David Conn
Posted Wednesday, March 06, 2013 11:29 PM
SSCommitted
Group: General Forum Members
Last Login: 2 days ago @ 2:06 PM
Points: 1,689,
Visits: 656
C. This was my first encounter with uninitialised variables.
When I declare an Integer for example I expect its value to be 0.
At least in T-SQL we can now give a Value on the Declare statement.
Post #1427783
opc.three
opc.three
Posted Wednesday, March 06, 2013 11:42 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 6,737,
Visits: 11,791
David Conn (3/6/2013)
C. This was my first encounter with uninitialised variables.
Thanks. I am pretty sure that aspect of C "fell off my memory queue" a long time ago
At least in T-SQL we can now give a Value on the Declare statement.
I like that too. We didn't have to worry about garbage in an uninitialized variable but that piece always seemed like one of the more obvious gaps in the language. Now that it is there the language feels that much more fluid and aligned with most of the other languages I work with, which is nice.
__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Believe you can and you're halfway there.
--Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler
--Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them.
--Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples.
--Giordy
Post #1427787
« Prev Topic
|
Next Topic »
49 posts, Page 5 of 5
««
«
1
2
3
4
5
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
