Viewing 9 posts - 16 through 24 (of 24 total)
Next piece of code will not give you the rows, but it contains a hint on what to use to find those rows 😉
WITH ListValues AS ( SELECT N'123' AS...
"Walking on water and developing software from a specification are easy if both are frozen." -- Edward V. Berard, "Life-Cycle Approaches"
March 21, 2013 at 2:25 am
When using ALTER-statements the table will not be re-created.
You will however receive an error when the ALTER-statement will not work.
For instance: if the data already in that column won't fit...
"Walking on water and developing software from a specification are easy if both are frozen." -- Edward V. Berard, "Life-Cycle Approaches"
March 20, 2013 at 3:38 am
You only show the trigger-code, but there is more code involved.
In your opening-post you mentioned that you can insert multiple rows at once.
How is that INSERT-part coded?
But I can tell...
"Walking on water and developing software from a specification are easy if both are frozen." -- Edward V. Berard, "Life-Cycle Approaches"
March 20, 2013 at 3:36 am
Yet another update on this issue:
Posted by Microsoft on 3/5/2013 at 11:50 AM
Hello Marc, We have now fixed this bug in the next major version of SQL Server. Thanks for...
"Walking on water and developing software from a specification are easy if both are frozen." -- Edward V. Berard, "Life-Cycle Approaches"
March 6, 2013 at 12:09 am
Thanks for reporting the issue. The problem is due to the $action column metadata which is incompatible with the literal collation (string values 'INSERT' or 'DELETE'). This should work without...
"Walking on water and developing software from a specification are easy if both are frozen." -- Edward V. Berard, "Life-Cycle Approaches"
December 7, 2012 at 12:34 am
A further update ...
I had a talk with Bob Beachemin about this issue ( and a few others stuff as well ).
He had a look at it and his conclusions...
"Walking on water and developing software from a specification are easy if both are frozen." -- Edward V. Berard, "Life-Cycle Approaches"
November 28, 2012 at 3:40 am
opc.three (11/13/2012)
In the contained database scenario $action is actually collated using the catalog default, i.e. Latin1_General_100_CI_AS_WS_KS_SC, per the table under...
"Walking on water and developing software from a specification are easy if both are frozen." -- Edward V. Berard, "Life-Cycle Approaches"
November 14, 2012 at 3:42 am
Really appreciate you looking in/at this issue.
The fact that you can reproduce the error by adding the COLLATE-clause is "as designed" in SQL Server.
Forget the SQL 2008 track for now.
The...
"Walking on water and developing software from a specification are easy if both are frozen." -- Edward V. Berard, "Life-Cycle Approaches"
November 13, 2012 at 6:47 am
D.Post (11/13/2012)
Hi,The only thing I can think of is replacing:
ON( Target.name = Source.name )with
ON( Target.name COLLATE Latin1_General_CI_AS = Source.name COLLATE Latin1_General_CI_AS )Hope this helps.
Yes, and no 😉
First: I'm aware...
"Walking on water and developing software from a specification are easy if both are frozen." -- Edward V. Berard, "Life-Cycle Approaches"
November 13, 2012 at 3:28 am
Viewing 9 posts - 16 through 24 (of 24 total)