![]() INSERT INTO student VALUES ( 'Harish Tejasvi' ,20,34546) ![]() INSERT INTO student VALUES ( 'Manoj singh' ,21,400) INSERT INTO student VALUES ( 'Suresh kumar' ,18,4599) INSERT INTO student VALUES ( 'Rakesh' ,19,4567) ( Sno INT IDENTITY(1,1), Name VARCHAR(50), Age INT, Code INT) Once you configured Database mail then you need to go through following steps.įirst we create a SQL Server table named as student then will insert some dummy records into table.Īfter that we will execute SQL Server database mail stored procedure inorder to send student table records into mail in text file. How to Configure SQL Server database Mail. If you do not know how to configure database mail for first time then you can read the post If you have configured SQL Server Database Mail then you can easily send query result as an attachment in mail body. How to send a SQL Server Query result in e-mail message?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |