Skip to content

Instantly share code, notes, and snippets.

View pascalberger's full-sized avatar

Pascal Berger pascalberger

View GitHub Profile
@pascalberger
pascalberger / Update-Force-Test-.md
Created April 3, 2023 21:15
Update Force Test Report #powershell #chocolatey
@pascalberger
pascalberger / Update-Force-Test-.md
Created April 3, 2023 21:12
Update Force Test Report #powershell #chocolatey
@pascalberger
pascalberger / Update-Force-Test-.md
Created April 1, 2023 20:28
Update Force Test Report #powershell #chocolatey
@pascalberger
pascalberger / Update-Force-Test-.md
Created April 1, 2023 19:59
Update Force Test Report #powershell #chocolatey
@pascalberger
pascalberger / Update-Force-Test-.md
Created April 1, 2023 19:40
Update Force Test Report #powershell #chocolatey
@pascalberger
pascalberger / Update-Force-Test-.md
Created April 1, 2023 19:39
Update Force Test Report #powershell #chocolatey
@pascalberger
pascalberger / Update-Force-Test-.md
Created April 1, 2023 19:35
Update Force Test Report #powershell #chocolatey

Keybase proof

I hereby claim:

  • I am pascalberger on github.
  • I am pberger (https://keybase.io/pberger) on keybase.
  • I have a public key ASDroHTw2jazELJBbTRkxGsygTc63ruCbsZzDO8f-SGIcAo

To claim this, I am signing this object:

@pascalberger
pascalberger / gist:3607bbb7c9dd94431f85a31b892fd3e0
Last active July 3, 2017 08:36
SQL Server Double.MaxValue default value issue
-- It is not possible to use .NET Double.MaxValue=1.7976931348623157E+308 as default value for a float field.
-- Error: The floating point value '1.797693134862316e+308' is out of the range of computer representation (8 bytes).
-- CREATE TABLE FloatDefaultReproduction (FieldInt integer, FieldFloat float DEFAULT (1.7976931348623157E+308));
-- Same error if max value representation as returned by SQL Server is used.
-- Error: The floating point value '1.79769313486232E+308' is out of the range of computer representation (8 bytes).
-- CREATE TABLE FloatDefaultReproduction (FieldInt integer, FieldFloat float DEFAULT (1.79769313486232E+308));
-- Workaround 1:
-- CREATE TABLE FloatDefaultReproduction (FieldInt integer, FieldFloat float DEFAULT ((CONVERT(float,'1.7976931348623157E+308'))));

Rendered as inline code block:

  • Foo
    foo
    Bar
    

Rendered as fenced code block: