Shnugo

Shnugo has asked 11 questions and find answers to 119 problems.

Stats

About

Started with GFA-Basic on Atari Mega-ST
Then VB5, little C++
Much with MS-Access (VBA)
Now a great enthusiast of C#
Lot of database experience (MS-SQL-Server)
structure aesthete
Lot of generic structures with generic skins
XML, XSL, XHTML, PDF: Transformations for WYSIWYG-documents

Shnugo questions

Strange CAST behaviour with INT and a single hyphen ( - )
Deploy SSRS reports on a customer's machine with PowerShell
Date conversion and culture: Difference between DATE and DATETIME

Shnugo answers

Add zeros in SQL columns
SQL Select: Take value from XML field
Generate single XML file from SQL Server with multiple results per customer
Query where date = '2016/01/02' not working?
SQL Server table audit trigger
How to import nested JSON to SQL Server table?
Msg 9402, Level 16, State 1, Line 9 XML parsing: line 1, character 38, unable to switch the encoding
Equivalent of MySQL HEX / UNHEX function in SQL Server?
Converting varchar(6) in HHmmss format to sql time format
SQL appending <?xml version="1.0" encoding="UTF-8"?> to Query output