declare @sql varchar(1000) select @sql='select * from '+right(left(convert(char(8),getdate(),112),6),4) exec(@sql)
select [name] from sysobject where [name] like '%%'
目前是这样方法传过来有(endTime and startTime){ int length = endTime.Day - startTime.Day; string sql = "select * from " + startTime.ToString("yyyyMMdd"); for (int i = 1; i <= length; i++) { sql += " union select * from " + startTime.AddDays(i).ToString("yyyyMMdd"); } 在开始与结束日期模糊查询
int length = endTime.Day - startTime.Day; string sql = "select * from " + startTime.ToString("yyyyMMdd"); for (int i = 1; i <= length; i++) { 在这里加上SQL 检查startTime.ToString("yyyyMMdd")表是否存在 这句不会你不会写吧 到网上找吧 一推推 sql += " union select * from " + startTime.AddDays(i).ToString("yyyyMMdd"); }
select * from sysobjects where id = object_id(N'[dbo].[table_name]') and OBJECTPROPERTY(id, N'IsUserTable') = 1 给你一个
select * from tb where time dt>=开始时间 and dt<=结束时间
select [name] from sysobject where [name] like '%%' select * from sysobjects where id = object_id(N'[dbo].[table_name]') and OBJECTPROPERTY(id, N'IsUserTable') = 1 给你一个
select @sql='select * from '+right(left(convert(char(8),getdate(),112),6),4)
exec(@sql)
int length = endTime.Day - startTime.Day;
string sql = "select * from " + startTime.ToString("yyyyMMdd");
for (int i = 1; i <= length; i++)
{
sql += " union select * from " + startTime.AddDays(i).ToString("yyyyMMdd");
}
在开始与结束日期模糊查询
string sql = "select * from " + startTime.ToString("yyyyMMdd");
for (int i = 1; i <= length; i++)
{
在这里加上SQL 检查startTime.ToString("yyyyMMdd")表是否存在 这句不会你不会写吧 到网上找吧 一推推
sql += " union select * from " + startTime.AddDays(i).ToString("yyyyMMdd");
}
object_id(N'[dbo].[table_name]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1 给你一个
select * from sysobjects where id =
object_id(N'[dbo].[table_name]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1 给你一个