[分享]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
