asp.net是不是不能执行创建sqlserver临时表的语句?
wnsre 2017-01-20 10:34:14 public static bool ExecSql(string str_sqltxt)
{
SqlConnection sqlConn;
string strConn = System.Configuration.ConfigurationManager.ConnectionStrings["string"].ConnectionString;
sqlConn = new SqlConnection(strConn);
sqlConn.Open();
SqlCommand cmd = new SqlCommand(str_sqltxt, sqlConn);
try
{
cmd.ExecuteNonQuery();
return true;
}
catch (Exception e)
{
return false;
}
finally
{
if (sqlConn.State != ConnectionState.Closed)
sqlConn.Close();
}
}
用这个语句 ExecSql("select distinct * into Tmp from aaab"); 能创建表tmp
用这个语句 ExecSql("select distinct * into #Tmp from aaab"); 却不能创建表#tmp
用这个语句 ExecSql("select distinct * into ##Tmp from aaab"); 却也不能创建表##tmp
是不是不能创建临时表?