USE [B2CShopDB]
GO
/****** Object:  StoredProcedure [dbo].[USER]    Script Date: 01/12/2015 09:44:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[USER]
AS
BEGIN
INSERT INTO dbo.[Categorys] VALUES(1)
END

===================================================

CREATE procedure [DBO].[USER]
AS
BEGIN
SELECT * FROM dbo.[Categorys]
INSERT INTO dbo.[Categorys] VALUES(1)
END

关于存储过程