SqlDbx
You are not logged in.
Pages: 1
I created speed type shortcut as follows
Shortcut: newproc
Substitution Value:
IF OBJECT_ID('dbo.xxx') IS NOT NULL
DROP PROC dbo.xxx
GO
CREATE PROC dbo.xxx
AS
-- DESCRIPTION:
-- PARAMETERS:
-- SAMPLE: EXEC xxx
BEGIN
END
Now when I type newproc in Editor Intellisense box pops up but it is very wide and can go outside the screen.
This is unexpected use for Speed Typing.
You could use SQL templates for something like this.
You are right about wide popup and it will be fixed in a next release.
Here's couple of improvements you can use.
Instead of newproc in Shortcut column type : newproc (name)
and in Substitution Value column type:
IF OBJECT_ID('dbo.$(name)') IS NOT NULL
DROP PROC dbo.$(name)
GO
CREATE PROC dbo.$(name)
AS
-- DESCRIPTION:
-- PARAMETERS:
-- SAMPLE: EXEC $(name)
BEGIN
END
Save and exit Speed Typing dialog.
Now in editor type newproc(sp_newproc) and see how it will be expanded.
Offline
Nice. Thank you
Pages: 1