从表中选择时间 [英] select time from tables

问题描述

我有一个表（table_1（userid，datetime）），它有30,000条记录。

现在我编写了一个函数，我在其中声明了表（@ table_2（userid，datetime）），如table_1 。

insert @ table_2

select * from table_1

现在@ table_2和table_1有相同的记录数。



在我的函数中我想选择datetime的userid基础哪一个更好我从@ table_2或table_1中选择



实际上当我以win形式创建报告时会出现错误操作超时。如果我从table_1中选择记录并明确计算报告日期。

在winform中

  public   void  getReportFrmServer（字符串报告，字符串 [] param）
 {
 尝试 
 {
  this  .reportViewer1.ServerReport.ReportPath =   / Report From_Iris_New / +报告; 
 ReportParameter [] parameter =  new  ReportParameter [ 1 ]; 
参数[ 0 ] =  new  ReportParameter（   startDate，param [ 0 ]）; 
  this  .reportViewer1.ServerReport.SetParameters（parameter）; 
  this  .reportViewer1.RefreshReport（）; 
 
 
} 
  catch （异常异常）
 {
 MessageBox.Show（exception） 。信息）; 
} 
 
} 

它给出错误操作超时



我尝试从sql server商业智能开发工作室生成报告

它会生成报告所以我认为ReportViewer会报告它会给出错误操作超时

解决方案

查看这个....





如何加快我的选择*查询530,000行 [ ^ ]





希望这会对你有所帮助。





干杯

从任何一个表中选择数据，因为这两个表都是彼此的复制品。

  public   void  getReportFrmServer（字符串报告，字符串 [] param）
 {
 尝试 
 {
  this  .reportViewer1.ServerReport.ReportPath =   / Report From_Iris_New / + report; 
  this  .reportViewer1.ServerReport.Timeout =  3600000 ; 
 ReportParameter [] parameter =  new  ReportParameter [ 1 ]; 
参数[ 0 ] =  new  ReportParameter（   startDate，param [ 0 ]）; 
  this  .reportViewer1.ServerReport.SetParameters（parameter）; 
  this  .reportViewer1.RefreshReport（）; 
 
 
} 
  catch （异常异常）
 {
 MessageBox.Show（exception） 。信息）; 
} 
 
} 

I have a table(table_1(userid,datetime)) which has 30,000 records.
Now I have written a function in which I declare table(@table_2(userid,datetime)) like table_1.
insert @table_2
select * from table_1
Now @table_2 and table_1 has same number of records.

in my function I want to select userid bases of datetime which one is better i select from @table_2 or table_1

actually when I create report in win form it gives an error "The Operation Time Out".If I select records from table_1 and make some calculation for report date wise.
In winform

public void getReportFrmServer(string report, string[] param)
      {
          try
          {
              this.reportViewer1.ServerReport.ReportPath = "/Report From_Iris_New/" + report;
              ReportParameter[] parameter = new ReportParameter[1];
              parameter[0] = new ReportParameter("startDate", param[0]);             
              this.reportViewer1.ServerReport.SetParameters(parameter);
              this.reportViewer1.RefreshReport();


          }
          catch (Exception exception)
          {
              MessageBox.Show(exception.Message);
          }

      }

it gives an error "The Operation Time Out"

I try to generate report from sql server business intelligence development studio
it generates report so I think ReportViewer does render report it gives error "The Operation Time Out"

解决方案

Hi,

Check this....


How Do I Speed Up My Select * Query Of "530,000" Rows[^]


Hope this will help you.


Cheers

Select data from any one of the table as both the tables are replica of each other.

public void getReportFrmServer(string report, string[] param)
      {
          try
          {
              this.reportViewer1.ServerReport.ReportPath = "/Report From_Iris_New/" + report;
  this.reportViewer1.ServerReport.Timeout = 3600000;
              ReportParameter[] parameter = new ReportParameter[1];
              parameter[0] = new ReportParameter("startDate", param[0]);
              this.reportViewer1.ServerReport.SetParameters(parameter);
              this.reportViewer1.RefreshReport();


          }
          catch (Exception exception)
          {
              MessageBox.Show(exception.Message);
          }

      }

这篇关于从表中选择时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！