Several Examples of Sending Mail by msdb.dbo.sp_send_dbmail Function in SQL Database
In the implementation system, from time to time, users put forward the hope that the system can automatically push mail. Because of the limited tools and capabilities at hand, many requirements are realized by using the mail trigger of sql server.
Steps:
1. Configure mailbox. Steps are simple, there are many posts on the Internet, manual direct ...
Posted by Pixelsize on Sat, 19 Jan 2019 22:00:13 -0800
Based on Spring Boot, use JPA to call stored procedures of Sql Server database and return record set
In last article "Based on Spring Boot, Complete CRUD with JPA Operating Sql Server Database" The CRUD operation of entity data using JPA is completed.
In some cases, then, some query statements are written in the stored procedure and returned to the recordset by the stored procedure.
Here, the call is completed by creating a named s ...
Posted by TheFreak on Wed, 26 Dec 2018 14:36:06 -0800
[bugfix] [Jingdong App Plug-in] Make sure other views do not use the same id
Plug-in has been widely used in the current mainstream app. Although the scheme is mature, there are still many pits emerging. Here is one of the problems that Jingdongdao has encountered when it is integrated into Jingdongdao App as a plug-in.
0x01. Crash Information Stack
---java.lang.IllegalArgumentException: Wrong sta ...
Posted by Nico on Fri, 14 Dec 2018 16:12:03 -0800