首先判断表是否存在,如果存在就删除然后重新创建。
private void CreatTable()
{
//删除CountContent表
strSql="if exists (select * from sysobjects where id = object_id(N'[CountContent]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [CountContent]";
SQLConn.ExecuteSql(strSql);
//创建CountContent表
strSql="CREATE TABLE [CountContent] (";
strSql+="[today] [bigint] NULL ,";
strSql+="[yesterday] [bigint] NULL ,";
......
SQLConn.ExecuteSql(strSql);
}
//SQLConn.cs
public static int ExecuteSql(string strSQL)
{
SqlConnection MyConn = new SqlConnection(GetSqlConnString());
SqlCommand MyComm = new SqlCommand(strSQL, MyConn);
try
{
MyConn.Open();
MyComm.ExecuteNonQuery();
return 0;
}
catch(System.Data.SqlClient.SqlException e)
{
throw new Exception(e.Message);
}
finally
{
MyComm.Dispose();
MyConn.Close();
}
}