I'm not sure if it's a bug, but it don't seem very usefull them.
When using the ALTER statements features I could write
ALTER PROC getEmploye <then press my completion key>
and the whole getEmploye proc get detailed like this
ALTER PROC getEmploye(@id_employe int)
AS
SELECT id_employe, courriel, domain_nt, username_nt FROM employe WHERE id_employe = @id_employe
But If I'm modified another proc for example getEmployeDossier here's is the code
ALTER PROC getEmployeDossier(@id_employe int)
AS
EXEC getDossier @id_employe = @id_employe
And I want to add a call to the getEmploye
I add this :
EXEC getEmploye<then press my completion key>
normally it would complete the getEmploye name, but when the ALTER statements is enabled the whole code from getEmploye is added
like this :
ALTER PROC getEmployeDossier(@id_employe int)
AS
EXEC getDossier @id_employe = @id_employe
EXEC getEmploye @id_employe = 0 -- int
(@id_employe int)
AS
SELECT id_employe, courriel, domain_nt, username_nt FROM employe WHERE id_employe = @id_employe
The result I wanted was this :
ALTER PROC getEmployeDossier(@id_employe int)
AS
EXEC getDossier @id_employe = @id_employe
EXEC getEmploye @id_employe = 0 --int
Thanks
Thanks for your post and detail explanation.
When using the ALTER statements features I could write
ALTER PROC getEmploye <then press my completion key>
and the whole getEmploye proc get detailed like this
ALTER PROC getEmploye(@id_employe int)
AS
SELECT id_employe, courriel, domain_nt, username_nt FROM employe WHERE id_employe = @id_employe
But If I'm modified another proc for example getEmployeDossier here's is the code
ALTER PROC getEmployeDossier(@id_employe int)
AS
EXEC getDossier @id_employe = @id_employe
And I want to add a call to the getEmploye
I add this :
EXEC getEmploye<then press my completion key>
normally it would complete the getEmploye name, but when the ALTER statements is enabled the whole code from getEmploye is added
like this :
ALTER PROC getEmployeDossier(@id_employe int)
AS
EXEC getDossier @id_employe = @id_employe
EXEC getEmploye @id_employe = 0 -- int
(@id_employe int)
AS
SELECT id_employe, courriel, domain_nt, username_nt FROM employe WHERE id_employe = @id_employe
The result I wanted was this :
ALTER PROC getEmployeDossier(@id_employe int)
AS
EXEC getDossier @id_employe = @id_employe
EXEC getEmploye @id_employe = 0 --int
Thanks