rickjamesb
MIS
Lets say you have a stored procedure INSERT a new row into a table. In this very same stored procedure what type of SELECT statement could you use just to display the values in the newly created row and not all the rows in that table?
For Example:
For Example:
Code:
CREATE PROCEDURE up_Insert_Region
AS
INSERT INTO Region (RegionID, RegionDescription)
VALUES (@RegionID, @RegionDescription)