USE [master]
GO
/****** Object: StoredProcedure [dbo].[sp_get_object_definition_to_file] Script Date: 05/10/2013 18:20:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF OBJECT_ID('[dbo].[sp_get_object_definition_to_file]') IS NOT NULL
DROP PROC [dbo].[sp_get_object_definition_to_file]
GO
--------------存储过程
CREATE PROCEDURE [dbo].[sp_get_object_definition_to_file]
@object NVARCHAR(128) = '' , --对象名
@object_type NVARCHAR(2) = '', --对象类型
@file NVARCHAR(128) = 'ALL' , --获取文件方式,ALL一个文件全部将对象语句保存下来,SINGLE将对象分别保存到单独文件
@file_type nvarchar(128) = '.sql', --保存格式
@path VARCHAR(255) = 'D:\DBGetObjectSQL' --保存的文件夹路径
AS
/*
作者:陈恩辉-弘恩
示例:
EXEC [dbo].[sp_get_object_definition_to_file] '','','ALL','.sql','D:\DBGetObjectSQL'
EXEC [dbo].[sp_get_object_definition_to_file] '','','SINGLE','.sql','D:\DBGetObjectSQL'
EXEC [dbo].[sp_get_object_definition_to_file] '','P','ALL','.sql','D:\DBGetObjectSQL'
EXEC [dbo].[sp_get_object_definition_to_file] '','FN','SINGLE','.sql','D:\DBGetObjectSQL'
*/
IF UPPER(ISNULL(@object_type,'')) NOT IN ('P','FN','TR','TF','V','') --不符合要求返回
BEGIN
SELECT ' @object_type 只能是P或FN或TR或TF或V ' return_result
RETURN
END
IF UPPER(@file) NOT IN('ALL','SINGLE') --不符合要求返回
BEGIN
SELECT ' @file 只能是ALL或SINGLE' retur