Modifying
a Stored Procedure
If you need to modify an existing stored
procedure, simply replace the CREATE with ALTER. Let's add a space in between
"Latest" and "Tasks" (i.e. make it "Latest
Tasks") and add the Description field:
ALTER PROCEDURE LatestTasks @Count int
AS
SET ROWCOUNT @Count
SELECT TaskName AS "Latest Tasks",
Description,
DateCreated
FROM Tasks
ORDER BY DateCreated DESC
No comments:
Post a Comment