//判断表是否存在 if not exists(select * from sysobjects where name='yourtablename' and xtype='u')
if not exists(select * from sysobjects where name='yourtablename' and xtype='u')
使用SQL Server的生成脚本功能,你可以在脚本中看到: IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[表名]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN CREATE TABLE [表名]( ... ) ON [PRIMARY] END 前面的SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[表名]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1 就是检查表是否存在
if not exists(select * from sysobjects where name='yourtablename' and xtype='u')
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[表名]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [表名](
...
) ON [PRIMARY]
END
前面的SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[表名]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1
就是检查表是否存在
如果存在就插入数据,如果不存在就创建表.这个在ASP.NET(C#)里应怎么去写?
请那位大师指点一下