摘要： USE tempdbIF EXISTS(SELECT * FROM msdb.dbo.sysjobs WHERE name='20秒一次的作业') EXEC msdb.dbo.sp_delete_job @job_name='20秒一次的作业'--定义创建作业DECLARE @jobid uniqueidentifierEXEC msdb.dbo.sp_add_job @job_name = N'20秒一次的作业', @job_id = @jobid OUTPUT--定义作业步骤DECLARE @sql nvarchar(400),@dbname 阅读全文

摘要： if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[f_Sql]') and xtype in (N'FN', N'IF', N'TF'))drop function [dbo].[f_Sql]GOif exists (select * from dbo.sysobjects where id = object_id(N'[序数表]') and OBJECTPROPERTY(id, N'IsUserTable') 阅读全文