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 25 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

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
SQL Server ALTER field NOT NULL takes forever