Shnugo

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

How a byte array is being stored in sql server table column of type Varbinary?
Can I improve the performance of this JSON conversion in SQL Server 2016?
JSON - How to append an array to an array in sql
How to extract hashtags from a string in T-SQL
To NULL particular fields in retrieval time in sql
SQL Server Pivot on multiple fields
Removing XML tags from FOR XML PATH
OPENXML does not return the expected result
How do I select the following string so it returns 3? SELECT '1+2'
XPath fn:data in sql server causes Type conversion in expression may affect "CardinalityEstimate" in query plan choice