解决方案 »
- C#根据主机名得到IP地址
- 将项目在自己电脑发布好了再拷到另外台电脑,再去iis配置就会报错,不懂
- DataGridViewCheckBoxColumn 如何变成 DataGridViewImageColumn
- 我用C#发信,请问哪个免费smtp能一次连续发送50个以上邮件
- 第一次用treeview。请教!
- 大家帮帮我吧,谢谢老师们了,一个VB.net2003中的访问主线程控件问题?
- 有sql express但没有sql studio express的电脑能还原已经备份的数据库吗(.bak)
- 【C#】Datagridview中Column重新排序,请教(坐等)
- 服务器提供的API如何解析返回的响应
- 这个list如何排序
- 求教无字段问题
- 关于asp.net 的问题。
根据你上面的情况,你完全可以写一个存储过程的嘛!
比如
create Procedure P_SelectSomthings
as
begin
declare @count int
Select @count=count(1) from tb_remind
if(@count>0)
begin
declare @days int
Select top 1 @days=Days from tb_remind
select PlanTitle,format(ExecuteTime,'yyyy-mm-dd') as ExecuteTime,PlanContent from tb_planreminder where right(convert(varchar(8),ExecuteTime,112),4) between and '0919'
end
end
as
begin
declare @count int
Select @count=count(1) from tb_remind
if(@count>0)
begin
declare @days int
Select top 1 @days=Days from tb_remind
select PlanTitle,format(ExecuteTime,'yyyy-mm-dd') as ExecuteTime,PlanContent from tb_planreminder where right(convert(varchar(8),ExecuteTime,112),4) between and '0919'
end
end
as
begin
declare @count int
Select @count=count(1) from tb_remind
if(@count>0)
begin
declare @days int
Select top 1 @days=Days from tb_remind
select PlanTitle,format(ExecuteTime,'yyyy-mm-dd') as ExecuteTime,PlanContent from tb_planreminder where right(convert(varchar(8),ExecuteTime,112),4) between and right(convert(varchar(8),DATEADD(day,@days,getdate()),112),4)
end
end