SQL存储过程创建重复问题

2017-11-08  本文已影响0人  a9b854aded01

存储过程

IF (EXISTS(SELECT * FROM sysobjects WHERE name='CustomerChargeSummarySelect' AND type='P'))
DROP PROCEDURE CustomerChargeSummarySelect
GO

CREATE PROCEDURE CustomerChargeSummarySelect

FUNCITON

IF (EXISTS(SELECT * FROM sysobjects WHERE id=object_id(N'[dbo].[f_csSplit]') AND (type='FN' OR type='TF')))
DROP FUNCTION [f_csSplit]
GO

CREATE FUNCTION [dbo].[f_csSplit]
上一篇 下一篇

猜你喜欢

热点阅读