September 16, 2019 at 12:00 am
Comments posted to this topic are about the item The typo
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
September 16, 2019 at 5:05 am
Nice question to start the week on, thanks Steve.
Of course, if there was a unique constraint on one or more columns of the table, the answer would have been 1 row inserted and 4 errors....
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
βlibera tute vulgaris exβ
September 16, 2019 at 10:05 am
I think you have just given away the answer to the next question π
September 16, 2019 at 2:25 pm
It depends. π
Is there a PK on the table on the pharmacy and/or claim no. If so you'd get one row inserted and 4 PK constraint violation errors.
September 16, 2019 at 3:21 pm
Assume no PK if not mentioned, and yes, likely aiming for similar questions in the future with other variations.
Or you should feel free to submit one π
https://qa.sqlservercentral.com/contributions
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply