Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase «««123

REPLICATE - 1 Expand / Collapse
Posted Monday, May 6, 2013 12:45 AM



Group: General Forum Members
Last Login: 2 days ago @ 2:09 AM
Points: 15,501, Visits: 13,163
Thanks for the question, and Hugo, thanks for the explanation

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1449598
Posted Monday, May 6, 2013 12:49 AM


Group: General Forum Members
Last Login: Wednesday, April 20, 2016 3:23 AM
Points: 6,049, Visits: 1,407
mtassin (5/3/2013)
I think we should give Hugo bonus points for another awesome explanation...

Good question no matter what, and an even more awesome explanation from Hugo

Yes, I agree......

Post #1449601
Posted Wednesday, May 8, 2013 7:11 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, November 24, 2016 7:31 AM
Points: 348, Visits: 292
nice question....

You cannot get to the top by sitting on your bottom.
Post #1450543
Posted Wednesday, May 15, 2013 2:02 AM

Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, May 23, 2016 5:31 AM
Points: 3,615, Visits: 2,774
Very good question and excellent explanation.
Post #1452965
Posted Monday, September 16, 2013 3:30 AM


Group: General Forum Members
Last Login: Friday, November 18, 2016 5:59 AM
Points: 174, Visits: 271
Hugo Kornelis (5/1/2013)
I think Ron expected the ANSI_WARNINGS setting to cause errors. Either because of the implicit conversion of 12.5 to integer, or because of the string truncation.
However ...

1. Rounding numerical data is not an overflow condition; AFAIK this does not raise an error regardless of ANSI_WARNINGS setting;
2. String truncation does cause an error to occur with ANSI_WARNINGS on - but only if it occurs while inserting or updating, not when assigning to a variable. This is mentioned explicitly in the Books Online article (

If you increase the length of @S to 11 characters or more, the effect of ANSI_WARNINGS does kick in. An error is returned during the INSERT statement, and the final SELECT returns nothing at all. (Since the INSERT errored, no row was inserted, so there is nothing to return).

Took me a while to understand, what you wrote there, Hugo, but:
"[...] string too large for database column [...]" in the article made it clear after all. Thanx for your explanation, Hugo, and also thanx to the author of the QotD!

If you set out to do something, something else must be done first.
Post #1494974
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse