Search results
14 wrz 2009 · We now have to create a pdf file. I was planning on using pdfsharp/migradoc to do it, but then we'd have to create document and time its readiness with sql server data state and mail state. It'd be nice if the db could handle everything.
18 lis 2008 · I want to display it always as "01","02","03" format. What is the best way to do it? declare @STR char(2); set @STR = '1'; select right('0' + ltrim(rtrim(@str)), 2); set @STR = ' 1'; select right...
2 cze 2021 · Using the new SQL scalar function GENERATE_PDF to create PDF in the IFS from spool files
7 maj 2013 · if (!TemplatePDF.IsNull) { //modify existing PDF document reader = new PdfReader(TemplatePDF.Stream); stamper = new PdfStamper(reader, PDFStream); canvas = stamper.GetOverContent(1); } else ...
28 lip 2017 · Let's start with a header of procedure or function we are documenting. Standard Header. There is not really something like a standard header, there are a few templates but they really boil down to basically the same. Let's have a look at SQL Server Management Studio standard header:
20 paź 2010 · begin as_pdf_mini.init; as_pdf_mini.set_format(‘A4′,’L’); select c2 into v_blob from test where c1=’a’; if v_blob is null  then as_pdf_mini.write(‘NULLLLLL’, 10,10); else as_pdf_mini.write(‘Not Null’, 10,10); as_pdf_mini.put_image(v_blob, 10,100,400,300); end if; as_pdf_mini.save_pdf (null,’a.pdf’); end;
16 kwi 2018 · The first, and simpler form uses the deprecated IFILTER function. CREATE OR REPLACE FUNCTION pdf_to_xml(p_pdf IN BLOB) RETURN XMLTYPE IS v_clob CLOB; v_xml XMLTYPE; BEGIN DBMS_LOB.createtemporary(v_clob, TRUE); DBMS_LOB.open(v_clob, DBMS_LOB.lob_readwrite); ctx_doc.ifilter(p_pdf, v_clob); DBMS_LOB.close(v_clob); -- This is an quick hack for ...
