DISQUS

DISQUS Hello!  The comments on this profile are unclaimed and thus are unverified.

Do they belong to you? Claim these comments.

Mathias Magnusson's picture

Unregistered

Feeds

aliases

  • Mathias Magnusson

Mathias Magnusson

10 months ago

in SQL Function Spotlight: TRIM on Eddie Awad’s Blog
I like using trim on dates. I have seen many elaborate ways of converting to char to remove it and then convert back to date. Using trim seems to be the slick way to just remove the time (making it zero).

1 year ago

in The Lazy Developer’s Way to Populate a Surrogate Key on Eddie Awad’s Blog
Isn't this an approach of rather than educating developers just accepting that they will cause you problems and solving that by making sure they have no way to assign the value.

I'm sure the developer would have wasted a few hours on figuring out why the keys used was +1 relative to the value he/she had provided. The only use of triggers I've found that is usable has been to work around software bugs while the software is bing fixed.

Triggers is one feature I've never liked. It hides things, and further slows things down. In this case, what happens the day you need to delete and reinsert the row? The key will change. It may not be likely that you would need to do a delete+insert, but it could happen.
Returning? Login