{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 ら.Afraid 的问题《send email from sql server express [closed]》','https://www.manongdao.com/q-1058527.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
i want to send an email as a user inserts some data into a table. is this possible in sql express? please help with the code.
i would use a trigger for insertion on the table. for email what features shall i have on my PC. i have Windows XP.
相关问题
- sql execution latency when assign to a variable
- What is the best way to cache a table from a (SQL)
- php PDO::FETCH_ASSOC doesnt detect select after ba
- Bulk update SQL Server C#
- SQL to Parse a Key-Value String
相关文章
- Entity Framework 4.3.1 failing to create (/open) a
- Code for inserting data into SQL Server database u
- How do I make a forward e-mail link?
- Delete Every Alternate Row in SQL
- Linux based PHP install connecting to MsSQL Server
- SQL Azure Reset autoincrement
- How do we alias a Sql Server instance name used in
- Is recursion good in SQL Server?
As far as I know, SQL Express does not support the Database Mail feature, so this would not be possible out of the box. As per the note at the bottom of the Database Mail MSDN article for Sql Server 2008 R2:
A more robust solution would be to embed the notification logic in the application tier (e.g C#) which talks to the database.
As far as I didn't find any deprecation against enabling SQL CLR onto SQL Server Express,
you can try to use SQL CLR Trigger with
System.Net.Mailobjects.This is not possible with SQL Express. If you happen to update to the full management studio you would use msdb.dbo.sp_send_dbmail to send your email.