Thing I would like to see in SQL - by Jerry Birchler

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 777285 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 1/23/2013 10:33:31 AM
Access Restriction Public

Description

First of all, SQL Server has come a long way. It's really a remarkable product.

1. ability to output variables as user defined tables so that a caller could consume multiple result sets into table variables

2. ability to create a user defined table type based on an existing table and have it keep pace with that table's schema changes

3. ability to model a new table creation from an existing and extend it with additional columns such that when model table is altered the new table is altered as well

4. lift the readonly limitation from user defined tables as passed variables

5. The ability to overload input parameters for a scalar valued function 

6. The ability to automatically update a column with the current time as a default constraint. Something like timestamp that actually is a time and cannot be overrode in an update query or ignored.

7. The ability to write data to a (real) table (not disk or table variable) inside a transaction so that data can be preserved even on rollback. Could prove very useful for audits, debugging, logs. Maybe a (hint) could be the mechanism?

8. Better tab management in SQL Server Management Studio. It's not unusual for me to have more than 10 tabs going and I have to save my queries to a file just to manage them without having to hunt for the query I want one tab at a time or remember its automatic name. Just thinking there is a simple solution to this that would greatly eliminate hunt time.

Sign in to post a comment.
Posted by Microsoft on 1/28/2013 at 3:37 PM
Hello Jerry,
Thanks for your feedback. Some of your requests are already covered by other items in connect like:

http://connect.microsoft.com/SQLServer/feedback/details/299296
http://connect.microsoft.com/SQLServer/feedback/details/127043

While others like request to add support to keep model & schema sync, I don't see us adding such feature in the engine. You can do this today with numerous tools - SQL Studio, Visual Studio, and 3rd party modeling tools.
Also, it will be good if you file individual requests rather than one since the teams that work on these features are different and each one tracks their work separately. So I am closing this item and feel free to search in connect for similar requests & vote or file new ones.

--
Umachamdar, SQL Programmability Team