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]