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. Has anyone created pdf files directly in sql server? And if so, how.
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:
1 kwi 2018 · If you have started to create a good collection of you own SQL Templates and snippets, then you may want to copy or share them from PC to PC or from user account to user account. You will find your personal templates here. C:\Users\{username}\AppData\Roaming\Microsoft\SQL Server Management Studio\14.0\Templates\Sql\{your personal folder}
7 maj 2013 · How to render PDF documents using SQL CLR. Also a good introduction on creating SQL CLR functions.
8 lip 2024 · Learn how to create document templates in a database table and use SQL to replace specific keywords in the templates for content customization.
12 wrz 2022 · Learn how to build conditional logic when writing SQL code using IF, BEGIN, END, ELSE, and ELSEIF logic.
1 cze 2021 · Fetch all names that start with any letter followed by 'atherine': SELECT name FROM names WHERE name LIKE '_atherine'; Fetch all names that end with 'a': SELECT name FROM names WHERE name LIKE '%a'; USEFUL FUNCTIONS. Get the count of characters in a string: SELECT LENGTH('LearnSQL.com');-- result: 12 Convert all letters to lowercase: SELECT ...
