KM.

Questions Linux Laravel Mysql Ubuntu Git Menu

HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin

KM. has asked 19 questions and find answers to 414 problems.

Stats

About

KM. questions

SQl Server tables: to heap or not to heap?
How to find what caused errors reported in a SQL Server profiler trace?
difficult HTML, JavaScript, CSS grid page
Any hidden pitfalls changing a column from varchar(8000) to varchar(max)?
best way to convert and validate a date string
FOR XML PATH(''): Escaping "special" characters
@@ERROR and/or TRY - CATCH
obfuscate or encrypt some plain text data in PHP
SQL Server how to drop identity from a column
How to create fixed table header rows that include colspans?

KM. answers

SQL Server 2008 - use cmd to output with headers to .csv
How to optimize retrieval of most occurring values (hundreds of millions of rows)
Script to generate default values for not columns with no defaults specified in SQL Server
How do I store date values partially?
SQL SUM() in a month on month report
Dynamically named temp table returns "invalid object name" when referenced in stored procedure
Sorting by ratings in a database - Where to put this SQL? (PHP/MySQL)
What is the best database design for multiple tables with 1 to 1 relationship to the same table?
Left join with group_concat is too slow
SQL Sub-Select, show only items that is not zero