- 博客(5)
- 收藏
- 关注
RSS订阅原创 C#邮件发送，收件人、抄送、秘抄、附件；（标题，主题，自定义编辑）单人多人均可
class Program { static void Main(string[] args) { SendEmailUtil.NetSendEmail("邮件内容_您好！","邮件主题_问候","您的标题问候", "[email protected],[email protected]", "[email protected],[email protected]", "[email protected]"); Console.ReadLin...
2020-11-25 17:43:47
1286
原创 Lamda链接查询、左连接内连接、分组、分页、排序
List<User> userList = new List<User> { new User {Id=1,Name="LiBai",Age=20}, new User {Id=2,Name="DuFu",Age=21}, new User {Id=3,Name="ZhangSan",Age=22} }; List<Book&...
2020-08-04 09:47:45
935
转载 Sqlserver数据库中查询所有表记录数据，最大表数据，最小表数据
if object_id(N'tempdb.db.#') is not nulldrop table #create table #(id int identity ,tblname varchar(50),num int)declare @name varchar(30)declare roy cursor for select name from sysobjects where xtype='U'open royfetch next from roy into @namewhile @@
2020-06-10 21:43:57
1881
原创 SqlServer、Mysql、Oracle语句添加【强制索引】
SqlServer添加强制索引：select * from tbl with (index=pk_ID) where tbl.ID=1关键字：index ，索引名称：pk_IDMysql添加强制索引：select a.ID,sum(b.age) as SumAge from tbl_Studentas a FORCE INDEX(IX_ID)where a.sex=1 group by a.IDFORCE INDEX(IX_ID) 函数加索引名称（IX_ID）...
2020-06-10 21:36:06
1148
1
原创 Quartz调度器
直接上代码，定时任务和策略 ：添加nuget包：Quartz（注意：依赖项，NETFranmework的版本，3.0基于最低版本4.5.2；）public class Program { //IJob:任务，定时执行 //ITriagger：策略 public static void Main(string[] args) { ScheduleTest().GetAwaiter().GetResult()...
2020-06-08 22:27:04
220
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人