| sudo apt-get install libxext-dev libxt-dev | |
| wget http://downloads.ghostscript.com/public/ghostpdl-9.05.tar.bz2 | |
| tar xjf ./ghostpdl-9.05.tar.gz | |
| cd ghostpdl-9.05/ | |
| ./configure | |
| echo '#define HAVE_SYS_TIME_H' >> xps/obj/gconfig_.h | |
| make xps | |
| ./xps/obj/gxps -dNOPAUSE -dBATCH -sDEVICE=pdfwrite -r150 -o /tmp/a.pdf ~/POWERPOINT.xps |
| IF 0 < ( | |
| SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES | |
| WHERE TABLE_TYPE = 'BASE TABLE' | |
| AND TABLE_SCHEMA = 'dbo' | |
| AND TABLE_NAME = 'T_SYS_Language_Forms' | |
| ) | |
| BEGIN | |
| -- Check for NULL values in the primary-key column | |
| IF 0 = (SELECT COUNT(*) FROM T_SYS_Language_Forms WHERE LANG_UID IS NULL) |
| -- You can split a string in SQL without needing a function: | |
| DECLARE @bla varchar(MAX) | |
| SET @bla = 'BED40DFC-F468-46DD-8017-00EF2FA3E4A4,64B59FC5-3F4D-4B0E-9A48-01F3D4F220B0,A611A108-97CA-42F3-A2E1-057165339719,E72D95EA-578F-45FC-88E5-075F66FD726C' | |
| -- http://stackoverflow.com/questions/14712864/how-to-query-values-from-xml-nodes | |
| SELECT | |
| x.XmlCol.value('.', 'varchar(36)') AS val | |
| FROM | |
| ( |
| # Makefile for a go project | |
| # | |
| # Author: Jon Eisen | |
| # site: joneisen.me | |
| # | |
| # Targets: | |
| # all: Builds the code | |
| # build: Builds the code | |
| # fmt: Formats the source files | |
| # clean: cleans the code |
Only files under 25 MB can be previewed with the Google Drive viewer.
Google Drive viewer helps you preview over 16 different file types, listed below:
| ;WITH baseTable AS | |
| ( | |
| SELECT 'RM1' AS RM, 'ADR1' AS ADR | |
| UNION ALL SELECT 'RM1' AS RM, 'ADR1' AS ADR | |
| UNION ALL SELECT 'RM2' AS RM, 'ADR1' AS ADR | |
| UNION ALL SELECT 'RM2' AS RM, 'ADR2' AS ADR | |
| UNION ALL SELECT 'RM2' AS RM, 'ADR2' AS ADR | |
| UNION ALL SELECT 'RM2' AS RM, 'ADR3' AS ADR | |
| UNION ALL SELECT 'RM3' AS RM, 'ADR1' AS ADR |
| -- 0a) Create Linked server | |
| -- 0b) Enable SPs for linked server | |
| -- EXEC sp_serveroption @server='CORDB2008R2', @optname='rpc', @optvalue='true' | |
| -- EXEC sp_serveroption @server='CORDB2008R2', @optname='rpc out', @optvalue='true' | |
| -- 1 Create database | |
| -- 2 Create types | |
| -- 3 Create table-synonyms |
| DECLARE @start int | |
| DECLARE @end int | |
| SET @start = 3 | |
| SET @end = 4 | |
| ;WITH CTE AS |
| --DROP SCHEMA [Import2] | |
| IF NOT EXISTS (SELECT name FROM sys.schemas WHERE name = N'Import2') | |
| EXECUTE('CREATE SCHEMA [Import2] AUTHORIZATION [dbo]') | |
| ; |
| /* | |
| exec sp_RPT_DATA_REM_Stundenuebersicht | |
| @in_mandant=N'0' | |
| ,@in_sprache=N'de' | |
| ,@in_standort=N'8adddbda-442b-4de4-a89e-a4e863ad7a72' | |
| ,@in_gebaeude=N'00000000-0000-0000-0000-000000000000' | |
| ,@in_portofolio_raum=N'00000000-0000-0000-0000-000000000000' | |
| ,@in_subportofolio_raum=N'00000000-0000-0000-0000-000000000000' | |
| ,@in_strasse=N'Alle' | |
| ,@in_geschoss=N'00000000-0000-0000-0000-000000000000' |
