[分享]SQL Server 2005 建立存储过程

如:建立这样的存储过程:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[dongtso888]

AS
SELECT * FROM [Content]

RETURN

但是你在写的时候要写成这样的:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
create PROCEDURE [dbo].[dongtso888]

AS
SELECT * FROM [Content]

RETURN

最后运行执行旁边的 小蓝钩进行分析,然后进行执行,

最后生成的就是dongtso888过程的内容就是这样的了:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[dongtso888]

AS
SELECT * FROM [Content]

RETURN