Search
SQL Server HomeDownloadsFeedbackSurveys
Refine Search Results
Status
Votes
Total Votes (at least)
Time
Created in the last (days)
Updated in the last (days)
Connection Search Results
Sort By:
You searched for: all feedback for this connection (signing in could show even more results)

Showing 1-10 of 2438 Previous 123 Next
142
Sign in to vote
4
Sign in to vote
Sign in
 to vote
Allow literals and read only table data to be represented as enums - by Simon Sabin
From Connection: SQL Server
It would be really useful to represent system values to be used in code as constants rather than having to hard code integer values. This means that lookup tables can use nice tinyints as the surr…
Created on 1/27/2007 (updated 1 week ago) | 3 workarounds | 14 comments | feedback id: 254293  | 
Active
136
Sign in to vote
1
Sign in to vote
Sign in
 to vote
Relax restriction that table parameters must be readonly when SPs call each other. - by Erland Sommarskog
From Connection: SQL Server
I was excited when I heard that Katmai would have table parameters, but I was equally disappointed to hear that they would be readonly. Today programmers employ various tricks to pass table data betwe…
Created on 9/23/2007 (updated 3 hours ago) | 0 workarounds | 15 comments | feedback id: 299296  | 
Active
132
Sign in to vote
3
Sign in to vote
Sign in
 to vote
CREATE OR REPLACE - by BAnVA
From Connection: SQL Server
Since I couldn't find a category called something like "T-SQL Syntax" I decided to post this here. Maybe I missed something in the CTP docs, but it appears that I will still have to do object exist…
Created on 11/3/2005 (updated 6 days ago) | 4 workarounds | 12 comments | feedback id: 127219  | 
Active
114
Sign in to vote
0
Sign in to vote
Sign in
 to vote
Enhanceents to LOOKUP - by Jamie Thomson
From Connection: SQL Server
A few problems with LOOKUP component: 1) Cannot set SQL statement that populates the LOOKUP cache dynamically. This means you cannot dynamically filter teh data in the cache - it would be a good idea…
Created on 11/28/2005 (updated 4 weeks ago) | 0 workarounds | 3 comments | feedback id: 127229  | 
Active
102
Sign in to vote
0
Sign in to vote
Sign in
 to vote
Add language and optimizer support for ISO <distinct predicate> - by Steve Kass
From Connection: SQL Server
SQL 1999 and later include the <distinct predicate> IS [NOT] DISTINCT FROM. The definition of distinct is (quoting from the 2003 standard) "informally, not equal, not both null." This is consistent…
Created on 7/7/2007 (updated 1 week ago) | 0 workarounds | 3 comments | feedback id: 286422  | 
Active
96
Sign in to vote
0
Sign in to vote
Sign in
 to vote
OVER clause enhancement request - LAG and LEAD functions - by Itzik Ben-Gan
From Connection: SQL Server
SQL Server 2005 introduced only partial support for the OVER clause. It is our strong believe that a more complete implementation of the OVER clause should be prioritized highly in consideration for f…
Created on 1/28/2007 (updated 10 hours ago) | 0 workarounds | 7 comments | feedback id: 254388  | 
Active
91
Sign in to vote
0
Sign in to vote
Sign in
 to vote
OVER clause enhancement request - ORDER BY for aggregates - by Itzik Ben-Gan
From Connection: SQL Server
SQL Server 2005 introduced only partial support for the OVER clause. It is our strong believe that a more complete implementation of the OVER clause should be prioritized highly in consideration for f…
Created on 1/28/2007 (updated 10 hours ago) | 0 workarounds | 1 comment | feedback id: 254387  | 
Active
87
Sign in to vote
0
Sign in to vote
Sign in
 to vote
OVER clause enhancement request - Progressive ordered calculations - by Itzik Ben-Gan
From Connection: SQL Server
SQL Server 2005 introduced only partial support for the OVER clause. It is our strong believe that a more complete implementation of the OVER clause should be prioritized highly in consideration for f…
Created on 1/28/2007 (updated 10 hours ago) | 0 workarounds | 1 comment | feedback id: 254397  | 
Active
85
Sign in to vote
7
Sign in to vote
Sign in
 to vote
ALTER TABLE syntax for changing column order - by PNPwi
From Connection: SQL Server
Changing the order of columns in a table requires the table to be dropped and recreated. As i look at the system tables, the order is simply stored as an integer but to change it requires a potential…
Created on 5/16/2005 (updated 1 week ago) | 1 workaround | 13 comments | feedback id: 124781  | 
Active
84
Sign in to vote
2
Sign in to vote
Sign in
 to vote
Expand synonym to other entities (database, linked server) - by AaronBertrand
From Connection: SQL Server
Synonyms provide a great layer of abstraction, allowing us to use friendly and/or local names for verbosely named or remote tables, views, procedures and functions. I have often felt that they are la…
Created on 11/18/2007 (updated 2 weeks ago) | 0 workarounds | 7 comments | feedback id: 311079  | 
Active

Showing 1-10 of 2438 Previous 123 Next
© 2009 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement