if object_id('dbo.u_dt_dqdm_cr_tab') is not null
drop procedure dbo.u_dt_dqdm_cr_tab
go
CREATE PROCEDURE dbo.u_dt_dqdm_cr_tab
@ssdq varchar(50) = null
AS
declare @tem_s_dqdm_tab as nvarchar(100)
declare @tem_sql_string as nvarchar(1024)
--执行删除表与建表的语句
Set @tem_s_dqdm_tab = '[dbo].[user_' + @ssdq + '_hrc21]'
Set @tem_sql_string = 'if exists (select * from dbo.sysobjects where id = object_id(N''' + @tem_s_dqdm_tab + ''') and OBJECTPROPERTY(id, N''IsUserTable'') = 1) drop table '+ @tem_s_dqdm_tab
exec (@tem_sql_string)