Shnugo

Shnugo has asked 11 questions and find answers to 115 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

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
What is the use of uc after constraint?
How can I avoid encoding when using "FOR XML PATH"?
Add separator when fetching values from XML in SQL
How a byte array is being stored in sql server table column of type Varbinary?