If a table has mixed not sparse column and sparse column,
edit data doesn't put sparse column into the sql command.
Change the fields list sql command with a "*" fix the bad.
Created on 1/18/2013 (updated 13 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 776900
|
|
|
Closed
as Won't Fix
|
|
You won't Fix this comment "multiple SELECT INTO #sametable in an local ambit fire a compile error".
But this creates absurd limitations.
The script on "Steps to Reproduce" fail!
This SQL behaviour…
Created on 10/18/2012 (updated 29 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 767931
|
|
|
Closed
as Won't Fix
|
|
A write operation should create an exclusive lock only on the modified rows.
So an update that sets only the variables, should not create exclusive locks.
On user tables or temporary SQL Server provi…
Created on 9/27/2012 (updated 22 weeks ago) | 0 validations | 1 workaround | 4 comments | feedback id: 764924
|
|
|
Resolved
as Won't Fix
|
|
The SQL documentation
http://msdn.microsoft.com/en-us/library/ms174383.aspx
report that REPLICATE() function return
"Returns the same type as string_expression."
But, with a binary parameter it retur…
Created on 5/31/2012 (updated 49 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 745159
|
|
|
Closed
as By Design
|
|
on
http://connect.microsoft.com/SQLServer/feedback/details/462053/the-filter-expression-of-a-filtered-index-is-lost-when-a-table-is-modified-by-the-table-designer
Long ago it was promised a fix for …
Created on 8/29/2011 (updated 1 week ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 686021
|
|
|
Closed
as Duplicate
|
|
When writing an UPDATE/DELETE command, you can not use a table name used as an alias in the FROM clause
Created on 10/13/2010 (updated 111 weeks ago) | 0 validations | 0 workarounds | 4 comments | feedback id: 613258
|
|
|
Closed
as By Design
|
|
A table function, where the select it'is ordered with an ORDER BY
clause, return unordered values.
It work on SQL SERVER 2000.
Created on 10/12/2010 (updated 111 weeks ago) | 0 validations | 0 workarounds | 3 comments | feedback id: 612787
|
|
|
Closed
as By Design
|
|
For several weeks,
the first time that I run an optimization,
I returned the following error.
If I repeat a second time, I have no errors
Created on 10/4/2010 (updated 99 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 610089
|
|
|
Closed
as Not Reproducible
|
|
Maybe not considered a bug,
but for me, in a declarative liguaggio,
the optimization should not change the behavior
of the code, let alone create or remove declarative errors
A side effect is that IS…
Created on 9/23/2010 (updated 111 weeks ago) | 0 validations | 0 workarounds | 2 comments | feedback id: 603990
|
|
|
Closed
as By Design
|
|
When ISNULL() is used, it can fail to return datatype values,
and the result is cut.
COALESCE() doesn't present this bug.
Created on 12/21/2009 (updated 167 weeks ago) | 2 validations | 0 workarounds | 9 comments | feedback id: 521546
|
|
|
Closed
as By Design
|
|