建立资料表不能用数字做名称?把" + createno + "改为英文就OK但用数字却不能,为什么呢?
Random r = new Random();
string createno = string.Empty;
createno = DateTime.Now.ToString("yyyyMMddHHmmss") + r.Next(100, 999).ToString(); string connString = WebConfigurationManager.ConnectionStrings["tlString"].ConnectionString;
SqlConnection conn = new SqlConnection(connString); conn.Open(); string SQL = "CREATE TABLE " + createno + " (id int IDENTITY PRIMARY KEY," +
"Name varchar (30)," +
"Subbranch varchar(30),"
+ "ErrorCode varchar(5))"; SqlCommand objCommand = new SqlCommand(SQL, conn); objCommand.ExecuteNonQuery(); conn.Close();
conn.Dispose();
Random r = new Random();
string createno = string.Empty;
createno = DateTime.Now.ToString("yyyyMMddHHmmss") + r.Next(100, 999).ToString(); string connString = WebConfigurationManager.ConnectionStrings["tlString"].ConnectionString;
SqlConnection conn = new SqlConnection(connString); conn.Open(); string SQL = "CREATE TABLE " + createno + " (id int IDENTITY PRIMARY KEY," +
"Name varchar (30)," +
"Subbranch varchar(30),"
+ "ErrorCode varchar(5))"; SqlCommand objCommand = new SqlCommand(SQL, conn); objCommand.ExecuteNonQuery(); conn.Close();
conn.Dispose();
string SQL = "CREATE TABLE " + createno + " (id int IDENTITY PRIMARY KEY," +
"Name varchar (30)," +
"Subbranch varchar(30),"
+ "ErrorCode varchar(5))";
改为
string SQL = "CREATE TABLE a" + createno + " (id int IDENTITY PRIMARY KEY," +
"Name varchar (30)," +
"Subbranch varchar(30),"
+ "ErrorCode varchar(5))";
结果资料库成功加入,是不是设定有误???
基本拉丁字符或其他国家/地区字符中的十进制数字。
at 符号、美元符号 ($)、数字符号或下划线。
标识符一定不能是 Transact-SQL 保留字。SQL Server 可以保留大写形式和小写形式的保留字。
不允许嵌入空格或其他特殊字符。
不允许使用增补字符。在 Transact-SQL 语句中使用标识符时,不符合这些规则的标识符必须由双引号或括号分隔。
但相當麻煩 ,
假如我要提取 资料表 內的名稱 ,
變做 Label 顯示出來能夠嗎 ?
變做 Label 顯示出來能夠嗎 ?