【文件属性】：
文件名称：sqlserver2005存储过程例子
文件大小：37KB
文件格式：TXT
更新时间：2012-08-20 07:38:33
游标，动态sql，存储过程调用
直接执行文件中的语句即可创建存储过程。
CREATE PROCEDURE [createReDealCheck]
-- Add the parameters for the stored procedure here
AS
BEGIN
declare @Cur_Error as integer
set @Cur_Error = 0
BEGIN TRANSACTION Tran_1
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
CREATE TABLE [dbo].[ReDealCheck](
[AppplyNo] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[FileType] [varchar](2) COLLATE Chinese_PRC_CI_AS NOT NULL,
[remark] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_ReDealCheck] PRIMARY KEY CLUSTERED
(
[AppplyNo] ASC,
[FileType] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
set @Cur_Error=@Cur_Error+@@error
CREATE NONCLUSTERED INDEX [index_LWMission_MissionProp1_MissionProp2] ON [dbo].[LWMission]
(
[MissionProp1] ASC,
[MissionProp2] ASC
)
INCLUDE ( [MissionID]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
set @Cur_Error=@Cur_Error+@@error
IF (@Cur_Error<>0)
begin
ROLLBACK TRANSACTION Tran_1
end
ELSE
begin
--ROLLBACK TRANSACTION Tran_1
COMMIT TRANSACTION Tran_1
end
END
网友评论
- 例子相对比较单一，对于初学者还是受用。希望网友能再写些逻辑性强一点的存储过程。对于初学者很有提升。