“@ate”传递参数附近的不正确语法

Question

当我执行这段代码时，我会得到一个错误

在“@ate”._附近不正确的语法，用户未处理的异常

请帮帮忙。

string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;

using (SqlConnection con = new SqlConnection(cs))
{  
    dat = "h1";

    SqlCommand ren = new SqlCommand();
    StringBuilder sbcomand = new StringBuilder("create table @ate (rno varchar, stat bit)");

    SqlParameter param = new SqlParameter("@ate",dat);
    ren.Parameters.Add(param);
    ren.CommandText = sbcomand.ToString();
    ren.CommandType = CommandType.Text;
    ren.Connection = con;

    con.Open();
    ren.ExecuteNonQuery();
    con.Close();
}

Answer 1

string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;

using (SqlConnection con = new SqlConnection(cs))
{  
    dat = "h1";
    string sbcomand = string.Format("create table {0} (rno varchar, stat bit)", dat );

    con.Open();
    using (SqlCommand command = new SqlCommand(sbcomand , con))
    command.ExecuteNonQuery();
    con.Close();
}