Oct 06 2022 04:32 AM
Hi,
SQL Server is certainly fond of introducing the shortened versions of keywords. For example, these statements are equal:
EXECUTE procedure_name
EXEC procedure_name
procedure_name
In this case typing the whole "EXECUTE" keyword seems redundant.
With that said, I would like to propose the creation of a new keyword, an alternate for CREATE OR ALTER:
*drumroll*
CREALTER - a simple, yet elegant way of delivering the same statement. Easily readable and understandable even for novice T-SQL Adepts.
I think it would be a worthy addition to the SQL SERVER Syntax.
Oct 06 2022 10:48 PM
procedure_name
CREALTER - a simple,
1. This is a community forum. MS employee may or may not read your post, so this is the wrong place for such requests => SQL · Community (azure.com)
2. Using only the store procedure name works only, if the call is the first & only command in a batch, otherwise it fails.
3. Really so lazy to type some more letters, so that you need shortcuts? Then you have the wrong job.
Note: Some of this "feature" are from Sybase times; MS may remove then in future.
Microsoft SQL Server - Wikipedia => Milestones.
Olaf