Microsoft SQL Server Express is a free version of Microsoft’s SQL Server, which is a resource for administering and creating databases, and performing data analysis. Much of the functionality of the non-free version of SQL Server is found in SQL Server Express, including the visual management tool SQL Management Studio and the ability to make use of stored procedures. New stored procedures for dbaseName are stored outside of the subfolder "System Stored Procedures," which is under ["Stored Procedures"]. On creating a new database, SQL Server fills the System Stored Procedures folder with scripts to maintain the database. SQL Server users don’t need to use these System Stored Procedures to create their own. Once the stored procedure is initially created, a new query tab opens. The tab contains a template or sample query, which the user then modifies to suit her purposes. USE [test] GO CREATE PROCEDURE [dbo].[mysp_selectstuff] AS – SET NOCOUNT ON added to prevent extra result sets from – interfering with SELECT statements. – SET NOCOUNT ON GO – Insert statements for procedure here SELECT * from dbo.Movies GO GO EXEC [dbo].[mysp_selectstuff] GO GO DROP PROCEDURE [dbo].[mysp_selectstuff] GO GO Writer Bio
