Question

C# sql 创建数据表 出错：“‘,’附近语法有语法错误” 数据库 conn已经打开

源代码如下：
string tablename =123；
String strUpdate = "Create TABLE "+ tablename + "( Row CHAR(25)," + "PointX DOUBLE, PointY DOUBLE,PointZ DOUBLE,Reliability DOUBLE )";
SqlCommand cmd = new SqlCommand(strUpdate, conn);
cmd.ExecuteNonQuery();
CREATE TABLE [dbo].[tablename](
[Row] [char](25) ,
[PointX] float ,
[PointY] [decimal](18, 2) ,
[PointZ] [decimal](18, 2) ,
[Reliability] [decimal](18, 2)
)
提示“123”对象名无效

Answer 1

MSSQL Server没有Double这个数据类型，可以使用 [decimal](18, 2)或float
如
CREATE TABLE [dbo].[T123](
[Row] [char](25) ,
[PointX] float ,
[PointY] [decimal](18, 2) ,
[PointZ] [decimal](18, 2) ,
[Reliability] [decimal](18, 2)
)

追问

将T123改为tablename后，老提示对象名无效

Answer 2

换个表名，或者加上双引号，123不是有效的标识符

Answer 3

String strUpdate = "Create TABLE "+ tablename + "( Row CHAR(25),PointX DOUBLE, PointY DOUBLE,PointZ DOUBLE,Reliability DOUBLE )";

Answer 4

convert转化为字符串

Answer 5

换个名字呗