从表中选择时间 [英] 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屋!