Try:1.new a stored procedure name "sp_checktable"; create procedure sp_checktable @tablename nvarchar(50) as begin
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[表名]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) select 0 else select 1 end 2.c# code: SqlConnection conn=new SqlConnection(connectionstring); SqlCommand cmd=new SqlCommand("sp_checktable",conn); cmd.CommandType=CommandType.StoredProceture; conn.Open(); SqlDataReader reader=cmd.ExecuteReader(); int i=-1; if(reader.Read()) i=int.Parse(reader[0].ToString()) if(i==0) Response.Write("table is not exists"); else if(i==1) Response.Write("table is exists")
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[表名]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
print '不存在'
GO
{Response.Write("表不存在");}
else
{Response.Write("表存在");}是这样吗?
create procedure sp_checktable
@tablename nvarchar(50)
as
begin
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[表名]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
select 0
else
select 1
end
2.c# code:
SqlConnection conn=new SqlConnection(connectionstring);
SqlCommand cmd=new SqlCommand("sp_checktable",conn);
cmd.CommandType=CommandType.StoredProceture;
conn.Open();
SqlDataReader reader=cmd.ExecuteReader();
int i=-1;
if(reader.Read())
i=int.Parse(reader[0].ToString())
if(i==0)
Response.Write("table is not exists");
else if(i==1)
Response.Write("table is exists")