Comments
Sort by recent activity
Thought I'd just add to this thread instead of make a new one.
When creating a stored procedure and wanting to call a second procedure in the first one, writing EXEC <partially_name_of_procedure> and hit enter when the dropdown list is on the correct one, you'll get the whole create statement for the SP. This should only appear if the name of the SP is prefixed by ALTER PROCEDURE in my opinion. It's a hassle to remember to completely type the SP name or cut away all the statements.
When creating / altering a view, SQL Prompt will not format the query properly.
Formatted:
SELECT
name ,
object_id ,
principal_id ,
schema_id ,
parent_object_id
FROM
sys.tables
Using view:
Formatted:
CREATE VIEW bob AS
SELECT
name ,
object_id ,
principal_id ,
schema_id ,
parent_object_id
FROM
sys.tables
In other news, the speed increase is very much noticed! / comments
Thought I'd just add to this thread instead of make a new one.
When creating a stored procedure and wanting to call a second procedure in the first one, writing EXEC <partially_name_of_procedure> a...