To create a stored procedure, follow the step described here, now alter the default stored procedure template like this
CREATE PROCEDURE GetAllPersonalDetails AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here SELECT * FROM PersonalDetails END
Here, we have removed any parameter name, replaced the SELECT statement with selecting all columns and all records (*) from the PersonalDetails database table.
Views: 11436 | Post Order: 86