CREATE PROCEDURE [dbo].[SpHuoQuZuiHouWeiZhiEx]
@p_CheId [int]
WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [DbServerSqlServer].[StoredProcedures].[SpHuoQuZuiHouWeiZhiEx]
GO
EXEC sys.sp_addextendedproperty @name=N'AutoDeployed', @value=N'yes' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'PROCEDURE',@level1name=N'SpHuoQuZuiHouWeiZhiEx'
GO
EXEC sys.sp_addextendedproperty @name=N'SqlAssemblyFile', @value=N'StoredProcedureZh.cs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'PROCEDURE',@level1name=N'SpHuoQuZuiHouWeiZhiEx'
GO
EXEC sys.sp_addextendedproperty @name=N'SqlAssemblyFileLine', @value=86 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'PROCEDURE',@level1name=N'SpHuoQuZuiHouWeiZhiEx'
@p_CheId [int]
WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [DbServerSqlServer].[StoredProcedures].[SpHuoQuZuiHouWeiZhiEx]
GO
EXEC sys.sp_addextendedproperty @name=N'AutoDeployed', @value=N'yes' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'PROCEDURE',@level1name=N'SpHuoQuZuiHouWeiZhiEx'
GO
EXEC sys.sp_addextendedproperty @name=N'SqlAssemblyFile', @value=N'StoredProcedureZh.cs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'PROCEDURE',@level1name=N'SpHuoQuZuiHouWeiZhiEx'
GO
EXEC sys.sp_addextendedproperty @name=N'SqlAssemblyFileLine', @value=86 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'PROCEDURE',@level1name=N'SpHuoQuZuiHouWeiZhiEx'
http://www.nokiamobile.org.cn/24_090928_10400627.html
CREATE PROCEDURE [dbo].[SpHuoQuZuiHouWeiZhiEx]
--定义一个int型变量
@p_CheId [int]
WITH EXECUTE AS CALLER
AS
--引用 DbServerSqlServer程序集中的 StoredProcedures类的 SpHuoQuZuiHouWeiZhiEx方法,创建存储过程前,需要在本地数据库中注册 DbServerSqlServer程序集
EXTERNAL NAME [DbServerSqlServer].[StoredProcedures].[SpHuoQuZuiHouWeiZhiEx]
GO
--执行系统存储过程sys.sp_addextendedproperty,为其传值。
EXEC sys.sp_addextendedproperty @name=N'AutoDeployed', @value=N'yes' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'PROCEDURE',@level1name=N'SpHuoQuZuiHouWeiZhiEx'
GO
EXEC sys.sp_addextendedproperty @name=N'SqlAssemblyFile', @value=N'StoredProcedureZh.cs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'PROCEDURE',@level1name=N'SpHuoQuZuiHouWeiZhiEx'
GO
EXEC sys.sp_addextendedproperty @name=N'SqlAssemblyFileLine', @value=86 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'PROCEDURE',@level1name=N'SpHuoQuZuiHouWeiZhiEx'
sp_addextendedproperty是用来添加描述信息的