if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spCheckDataFor]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[spCheckDataFor]
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
,我用过了几个,但都不像这么全,不知哪个工具能实现这种功能?
...全文
1729打赏收藏
请教各位,SQL中的表,存储过程,视图,函数导出大家都用什么工具?
如题, 能够将一次可以将所有被选定的表,存储过程,视图,函数导出,并且每个前面都要有判断是否存在的语句存在,如下例: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spCheckDataFor]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[spCheckDataFor] GO SET QUOTED_IDENTIF