Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pradeep_iete
Yak Posting Veteran
84 Posts |
 Posted - 2008-05-26 : 05:20:18
|
| Please Concentrate on colored TSQL;I should i pass dynamic text to database mail in @body. Declare @charstrn varchar(20); Declare @C_name varchar(20); Declare @l_code nvarchar(20);SET @charstrn = @S_name+'Welcome to India.You are now registered Student under counslerName'+@C_name+'BranchOffice'+@l_code; EXEC msdb.dbo.sp_send_dbmail @profile_name = 'Pradeepvarun', @recipients = @emailid , @body = (select @charstrn), @subject = 'You are now Registered in APT'; |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-05-26 : 05:35:22
|
| SET @charstrn = @S_name+' Welcome to India.You are now registered Student under counslerName '+@C_name+' BranchOffice '+@l_code;EXEC msdb.dbo.sp_send_dbmail @profile_name = 'Pradeepvarun', @recipients = @emailid ,@body = @charstrn, @subject = 'You are now Registered in APT';_______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
 |
|
|
|
|
|
Database Mail