CREATE OR ALTER statement - by Rafs

Status : 

 


30
0
Sign in
to vote
ID 344991 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 5/19/2008 10:01:25 PM
Duplicates 351217 Access Restriction Public
Primary Feedback Item 127219

Description

It's desirable for SQL Server 2008 to have a kind of CREATE OR ALTER statement in T-SQL for objects creation.

While it seems to be unimportant feature, it's a desirable feature that safe some typing and simplify scripting. I've suggested that feature for SQL Server 2005, and it was dropped on the Beta. Said it would ship in a future version. I don't see the feature in any CTP of SQL Server 2008. I don't how can it be so dificult to implement it, since T-SQL has received so many improvements since SQL 2000, why not a so simple one like this?
Sign in to post a comment.
Posted by Levente0xFFFD on 8/8/2014 at 7:01 AM
I'm still not able to open the primary feedback item. It says "The system has encountered an unexpected error. We apologize for the inconvenience. The issue will be addressed as quickly as possible.".
Posted by ArthurZ on 3/27/2014 at 6:57 AM
This is a much awaited "syntactic sugar" productivity boost that exists in other RDBMS implementations for a long time.
This addition also appears to be a non-breaking change.
Besides, both links to duplicate posts above don't resolve due to: "The system has encountered an unexpected error."
Posted by Microsoft on 3/24/2010 at 2:15 PM
Hi,
I have resolved this request as duplicate of feedback item below:

https://connect.microsoft.com/SQLServer/feedback/details/127219/create-or-replace

--
Umachandar, SQL Programmability Team
Posted by AaronBertrand on 5/25/2008 at 7:53 AM
This is a duplicate request. Better to add voting weight to the following item, instead of spreading it out:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=127219
Posted by Microsoft on 5/20/2008 at 3:18 PM
Thanks for the valuable suggestion.

Given the release schedule, we're not able to make it as part of SQL Server 2008.

On the other hand, it's being considered as a top feature in our TSQL enhancement list for the next major release.

thanks