USE NAGEBOARD
GO
IF EXISTS(SELECT name from sysobjects WHERE name='crttable' AND type='p')
DROP PROCEDURE crttable
GO
USE NAGEBOARD
GO
CREATE proc crttable
as
declare @nalja varchar(10)
declare @nalja1 varchar(10)
set @nalja= convert(varchar(30), getdate(),12)
set @nalja1= convert(varchar(30), getdate()-1,12)
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade'+@nalja+']') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
return
end
else
begin
exec crttable_trade
end
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[itemtrade'+@nalja1 +']') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
exec deltable_item1
end
下载声明:
本站资源均有第三方用户自行上传分享推荐,非本站自制,仅供玩家做交流学习之用!切勿用于商业用途!游戏作品版权归原作者享有,如有版权问题,请附带版权证明至邮件,本平台将应您的要求删除。
举报邮箱 :znzpzy@163.com
评论