Quick one.
Do you think it would be useful to be able to do this:
ALTER TABLE t
ALTER COLUMN c1 int null
ALTER COLUMN c2 int null
ALTER COLUMN c3 int null
ALTER COLUMN c4 int null;
instead of this:
ALTER TABLE t ALTER COLUMN c1 int null;
ALTER TABLE t ALTER COLUMN c2 int null;
ALTER TABLE t ALTER COLUMN c3 int null;
ALTER TABLE t ALTER COLUMN c4 int null;
If the answer's 'yes', head here: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=351514 and vote for it to be implemented in a future version of SQL Server.
-Jamie
UPDATE: I've just thought of another one.
In SQL 2005 you have to write this:
declare @i int
select @i = dbo.udf_MyScalarFunction()
exec usp_MyStoredProc @i
In SQL 2008 its a little bit nicer because you can write this:
declare @i int = dbo.udf_MyScalarFunction()
exec usp_MyStoredProc @i
but wouldn't it be good if we could just do this:
exec usp_MyStoredProc dbo.udf_MyScalarFunction()
instead?
If you agree, go here: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=352110 and vote for it.
-Jamie