如何判断表存在则跳过,不存在则建立呢

[icejd]

请看这个帖子
http://topic.csdn.net/u/20071208/16/fe674aec-1fef-4e89-97db-f9fdc3413ad0.html
非常感谢

[火星求索]

--版主给你写的代码里有存在的判断

set @lstr1='if exists (select * from dbo.sysobjects where id = object_id(N''dbo.['
    +@tablename+']'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1) drop table dbo.['
    +@tablename+']'

[Limpire]

create procedure createMytable  @tablename varchar(50)
as

if object_id(@tablename) is not null
return

-->以下代码同

[中国风]

if not exists(select 1 from sysobjects where Name=@tablename and xtyp='U')
begin
..............语句
end

[cxmcxm]

楼上的都可以,
2楼的最简单吧.


http://topic.csdn.net/u/20071208/16/fe674aec-1fef-4e89-97db-f9fdc3413ad0.html
中的存储过程我只是按你给的代码转换而已.

[icejd]

谢谢各位啦,我没分啦,以后再来回报大家