26 items | 2 visits
Cesar Vega's List: Programming SQL Server
-
-
-
-
Jun 08, 12
"DECLARE @sql VARCHAR(1000)
SET @sql = 'BCP "SELECT ImageColumn FROM YourTable where id = 1 " QUERYOUT C:\TEMP\MyLogo.gif -T -fC:\TEMP\bcpFormat.fmt -S ' + @@SERVERNAME
EXEC master.dbo.xp_CmdShell @sql
exec msdb.dbo.sp_send_dbmail
@profile_name = 'MyProfile',
@recipients = 'bob@hotmail.com',
@subject = 'test as image',
@body=N'<p>Image Test</p><img src="MyLogo.gif" /><p>See image there?</p>',
@file_attachments = 'C:\TEMP\MyLogo.gif',
@body_format = 'HTML';" -
-
Jul 05, 12
"I followed that advice and set the ConnectionModifier to public, then before I called the Fill() method on my TableAdapter, I created a new connection (with a different connection string) and assigned it to the TableAdapter.
"
List Comments
(0)
List Info