deroby

Questions Linux Laravel Mysql Ubuntu Git Menu

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

deroby has asked 8 questions and find answers to 26 problems.

Stats

About

deroby questions

FULL OUTER JOIN with filtered data
Can INSERT <table> (x) VALUES (@x) WHERE NOT EXISTS ( SELECT * FROM <table> WHERE x = @x) cause duplicates?
c# SqlDecimal flipping sign in multiplication of small numbers
Strange behaviour of CASE construction
SQL Management Studio 2008 R2 "wrongly" reconnects after connection loss

deroby answers

Yet another LEFT OUTER JOIN fail in SQL Server 2012 Express
How do I Populate a Result View Column with Value from Stored Proc in SQL?
Why is this sql script so slow and how to make it lightning fast?
Window Functions - Running Total with reset
How to retrieve server generated Identity values when using SqlBulkCopy
Storing trillions of document similarities
UPDATE statement uses EXEC to execute a stored procedure to SET a column value
Generating random values from uniform distribution with setting a seed in T-SQL
Inserting nested entities with autoincrement using SQL Server
Allowing a stored procedure to select from a system table using a certificate in SQL Server 2012