Demo 1 - Email HTML | Demo
2 - Email PDF | Demo 3 - SQL to PDF | Demo
4 - Embedded Queries
Demo 5 - Prescheduled Queue | Demo
6 - Dynamic Queue | Demo 7 - Zip &
Password-Protect
Demo 8 - Mail Merge | Demo 9 -
Content Path | Demo 10 -
Excel Workbook | Demo 11 -
Word/RTF
Demo 3 - loading PDF directly from SQL.
| Description |
This demo does not send an email but rather retrieves results from a SQL query
in PDF format. This would be useful if, let's say, you wanted to run a query in
the Query Analyzer and get results back in PDF, or if you wanted to call a SQL
statement from ADO.NET or ADO and get back a resultset formatted as PDF (HTML
and TEXT formats are also supported). To run the demo, click on the Run Demo 3
button, then copy and paste PDF results from the text area below. You will need
to copy the results into the Notepad and then save the file as ANSI with .PDF
extension. |
| |
|
| SQL Code |
exec sp_SendSAM
@query='select top 100 CustomerID, OrderDate,
ShippedDate, Freight, Shipname, ShipRegion
from Northwind..Orders
/*<title>Northeast Orders</title>*/',
@call_mode='STRING',
@format='PDF'
|
| Results |
|