SDdemon

摘要： 1 查看数据库是否存在该表 2 方法1 3 select distinct object_name(id) from syscomments where id in 4 (select id from sysobjects where type ='P') and text like '%Bak%' 阅读全文

摘要： 1 IF OBJECT_ID('tempdb.dbo.#tmp', 'U') IS NOT NULL 2 DROP TABLE dbo.#tmp; 3 GO 4 CREATE TABLE #tmp (id UNIQUEIDENTIFIER,Iphone VARCHAR(50),PerID INT,a 阅读全文